sum columns with formula

  • Thread starter Thread starter Kenny
  • Start date Start date
K

Kenny

I am having problems trying to add a group of cells that
are totals of other cells. eg. cells A1 to A10 are sums
of a range of cells in sheet 1 through 10. I am trying to
put a formula in A11 that sums A1 through A10 but if any
of the cells in A1 through A10 are blank then I get value.
I have tried making this formula an array but that doesn't
work. This is likely very simple but then again I
probably am too. Hope someone can help. Thanks.

Ken
 
My guess is your using something like =A1+A2+A3+....
in A11. This will error out if any cells contain text. Try
using this instead:

=SUM(A1:A10)

SUM will ignore text entries.

HTH
Jason
Atlanta, GA
 
Back
Top