Multiple cells and ignore empty cell

Hi,

is there a way to make a formula that multiplies 3 cells and ignores if one of the cells is empty?

Here is a short example of the problem:

=sum(a1*b1*c1) works, but if b1 is empty it returns 0, and that is how it should work, but I need to have it so that if one of those cells is empty, it ignores it and multiplies those only that have a value?

Thanks,

-F

Maybe the SUMIF function will work for you.

This array formula (confirmed with Ctrl+Shift+Enter instead of Enter) returns 0 if all cells are blank, otherwise the product treating blanks as 1:

=PRODUCT(IF(A1:A3<>0, A1:A3))

Or, if you want all blanks to return 1, then this array formula:

=PRODUCT( (A1:A3 = 0) + A1:A3)

Try something like that:
=IF(A1=0,1,A1)*IF(B1=0,1,B1)*IF(C1=0,1,C1)

Thanks all for your help. Solved the problem with PCI's suggestion.


-F