[Vi]

I have added a column of numbers using the following formula so the total
cell will be zero if there is nothing in the column:
=IF(count(F8:F26),SUM(F8:F26),""

Now I want to multiply that total by cell F27 and put the total in cell F28.
Again, if the total is zero, I want the cell to be blank.

Please help

[HKaplan]

Why the complicated formula?

=sum(F8:F26) will return 0 if F8:F26 is empty anyway. You don't need
to test for cells with data.

[PCLIVE]

On way:

=IF(IF(COUNT(F8:F26),SUM(F8:F26)*F27,"")=0,"",IF(C OUNT(F8:F26),SUM(F8:F26)*F27,""))

HTH,
Paul

--

"Vi" wrote in message
...
I have added a column of numbers using the following formula so the total
cell will be zero if there is nothing in the column:
=IF(count(F8:F26),SUM(F8:F26),""

Now I want to multiply that total by cell F27 and put the total in cell
F28.
Again, if the total is zero, I want the cell to be blank.

Please help

[Vi]

I don't want the zero to show up because it is on a form that we print out
and some people fill it out by hand instead of on the computer.

"HKaplan" wrote:

Why the complicated formula?

=sum(F8:F26) will return 0 if F8:F26 is empty anyway. You don't need
to test for cells with data.

[HKaplan]

Go to Tools | Options, and uncheck the zero values in the View tab.
Then zero values will all be blank.

[Vi]

This did not work - it did not give me an answer at all when there was
something in the column.

"Vi" wrote:

I have added a column of numbers using the following formula so the total
cell will be zero if there is nothing in the column:
=IF(count(F8:F26),SUM(F8:F26),""

Now I want to multiply that total by cell F27 and put the total in cell F28.
Again, if the total is zero, I want the cell to be blank.

Please help

[HKaplan]

Try simplifying the formula as I suggested, leaving out the count
statement. =sum(A1:A20) is all you need to total a column. If the
answer is zero, then the cell will be blank.

[David Biddulph[_2_]]

You'll need to tell us what non-standard settings you are using. By
default, that would return zero. Perhaps you have display of zeroes
suppressed?
--
David Biddulph

"HKaplan" wrote in message
...
Try simplifying the formula as I suggested, leaving out the count
statement. =sum(A1:A20) is all you need to total a column. If the
answer is zero, then the cell will be blank.