I need to add several rows of numbers, say A1:A10 and B1:B10, etc... I need
it to add all NONBLANK cells and display the result in cell A11, B11, etc...-
including those that have a zero in a cell rather than just a blank cell.

The trouble I am having is in those rows that have all BLANK cells, still
shows the sum of that row as zero, when actually it should be blank as there
are no entries.

In the rows where there are no numbers higher than a zero, but there is at
least one zero, the sum of that row SHOULD show zero.

Any ideas??

thanks

Try

=IF(COUNT(A1:A10)0,SUM(A1:A10),"")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Troubled" wrote in message
...
I need to add several rows of numbers, say A1:A10 and B1:B10, etc... I
need
it to add all NONBLANK cells and display the result in cell A11, B11,
etc...-
including those that have a zero in a cell rather than just a blank cell.

The trouble I am having is in those rows that have all BLANK cells, still
shows the sum of that row as zero, when actually it should be blank as
there
are no entries.

In the rows where there are no numbers higher than a zero, but there is at
least one zero, the sum of that row SHOULD show zero.

Any ideas??

thanks

That's it! Thanks!

"Chip Pearson" wrote:

Try

=IF(COUNT(A1:A10)0,SUM(A1:A10),"")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Troubled" wrote in message
...
I need to add several rows of numbers, say A1:A10 and B1:B10, etc... I
need
it to add all NONBLANK cells and display the result in cell A11, B11,
etc...-
including those that have a zero in a cell rather than just a blank cell.

The trouble I am having is in those rows that have all BLANK cells, still
shows the sum of that row as zero, when actually it should be blank as
there
are no entries.

In the rows where there are no numbers higher than a zero, but there is at
least one zero, the sum of that row SHOULD show zero.

Any ideas??

thanks