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
=======
