Addition & multiplication formula

V

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
 
P

PCLIVE

On way:

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

HTH,
Paul
 
V

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.
 
V

Vi

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

David Biddulph

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Prompted data entry 0
Cumulative formula for word table 0
Cell ref is it possibile to calculate / change this in a formula 3
Drop List + Formula 1
Consolidation Table from Different Excel Tabs with Different Format 1
My formula gives a wrong total...help! 3
Excel does not accept text format! 0

Top