Addition problem

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

Dear All
I hope this is the right group, as I don't often post.

I have a large spreadsheet with a currency column, whereby someone puts
in a quantity in column A and it automatically works out a Price due in
column H.

I need to let column H add up a total amount due in the last cell at the
bottom of the column.

I have tried manually putting in "=SUM(H13:H2671)" and also highlighted
all the relevant cells and clicking on the quick sum icon, but all I
keep getting in the last cell is; #VALUE!

As I have done this before with no problem, I am wondering what I am
doing wrong this time.

Any help appreciated.

Barry
 
Check for an error in H13:H2671.

Maybe in a hidden row (either hidden manually or via filtering???).
 
Dear Dave
Many thanks, when you know what to look for it is easy!
I found the errors and cleared the relevant cells and now it work!
Again thanks for taking the time to help
Regards
Barry
 
Back
Top