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))
Frank .SBuilding EstimatorAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor 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
 
Richard DanekeTrainerCommented:
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
 
Frank .SBuilding EstimatorAuthor Commented:
hI dodahd, thanks i'll try your solution also.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)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.

All Courses

From novice to tech pro — start learning today.