MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula for Totals


Posted by Paulino on January 02, 2002 11:07 AM

Years ago, I used a formula to add a total that would only show the total if at least one value was entered in one of the cells. Otherwise, the cell would be blank. Is anyone know how to create that formula?


Posted by Jack in UK on January 02, 2002 11:11 AM

Hi
Try =Sum(A1:A5)

{it in A6 will add all of A1 to A5 if numbers, something like that in mind?
HTH
Jack

Posted by Aladin Akyurek on January 02, 2002 11:16 AM

I think it must be something like:

=IF(COUNTIF(A1:A5,"<>0"),SUM(A1:A5),"")

Aladin

Posted by Aladin Akyurek on January 02, 2002 11:39 AM

=IF(COUNT(A1:A5),SUM(A1:A5),"")

after Scott (see replies below on the earlier post).

Aladin

=======