# EXCEL FORMULA

Hi i would like some assistance with the following formula. What im trying to do is;
if the value of cells I33:I48 = zero or nothing, leave blank, otherwise sum cells I33:I48

=IF(SUMPRODUCT(I33:I48)="","",SUMPRODUCT(I33:I48))
###### Who is Participating?

Microsoft MVP ExcelCommented:
Hello,

maybe

=if(sum(I33:I48)=0,"",sum(I33:I48))

or

=if(count(I33:I48)=0,"",sum(I33:I48))

The first one will return a blank even if the cells contain a 0, the second one will return  a blank only if all cells are empty.

cheers, teylyn
0

TrainerCommented:
Frank,
I would use the Sum option.  The value will be zero for any combination of cells that are blank, null, or 0.
But, I think the formula should be:  =if(Sum(I33:I48)=0,"",SUMPRODUCT(I33:I48))

I am curious as to what a SUMPRODUCT answer provides for a range of numbers?
0

Building EstimatorAuthor Commented:
hI dodahd, thanks i'll try your solution also.
0

Microsoft MVP ExcelCommented:
Sumproduct() with just one range parameter produces the same result as Sum(). Sumproduct() is a very powerful function, but in this scenario I don't see how it would be beneficial.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.