Addition & multiplication formula
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
|