Why won't a simple SUM formuila work?

[Malthus101]

Adding a column of numbers (% percentages)

worked on last sheet - copied the formula - now doesn't work on this sheet - why?

thanks.

 

[Fluff]

It doesn't work as you have #div/0 errors in the range. Either get rid of them or use

=AGGREGATE(9,6,J4:J100)

 

[Malthus101]

It doesn't work as you have #div/0 errors in the range. Either get rid of them or use

=AGGREGATE(9,6,J4:J100)

Hi, right I see.

But the only reason they are in there is to ensure the formulas will automatically work when the reference cells are filed in.

I think there are fundamental things I don't understand about how to use formulas!

Thanks.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Malthus101]

What should I be doing to ensure the formulas are waiting active in those cells to auto-calc as more data is added to the sheet, but also not interfere with the "total" number being added in that cell at the top?

Thanks.

 

[Fluff]

You can just use the formula I supplied.