How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Kamil Anwar Your Own Question
Kamil Anwar
Kamil Anwar, Computer Support Specialist
Category: Computer
Satisfied Customers: 172
Experience:  8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
69350257
Type Your Computer Question Here...
Kamil Anwar is online now

I use an excel spreadsheet accounts. I always

Customer Question

Hi
I use an excel spreadsheet for my accounts. I always put in any invoices I send in a column (K). When I have been paid I copy and paste that cell from K to L and M Columns.
This has worked well until recently when all the K column information seems to have transferred to column L and M leaving the whole of K column blank. However, at the bottom of K column is a Sum function which still shows the sum of those entries in K column? Any ideas what is going on and how do I correct it because now I cant tell who has paid and who has not.
Thanks
Howard
Submitted: 2 years ago.
Category: Computer
Expert:  The-PC-Guy replied 2 years ago.
can you tell me exactly what the formula says
Customer: replied 2 years ago.

The formula at the bottom of K column is

=Sum(K4:K106)

Can I send you the spread sheet?

Howard

Expert:  The-PC-Guy replied 2 years ago.
sure , click the paperclip icon, at the top of this chat window
Customer: replied 2 years ago.

HELLO

Are you able to help me please.

Dr H Jackson

Customer: replied 2 years ago.

Sorry cant see the paperclip icon

Howard

Customer: replied 2 years ago.

It's okay, my genius daughter has fixed this.

Expert:  The-PC-Guy replied 2 years ago.
sorry, so you no longer need help?
Customer: replied 2 years ago.

No thank you. Apparently it collapsed all rows with entries in the K column. Sorted now though THanks

Howard