Please help with SumIf

[Guest]

What am I doing wrong with this formula?

=SUMIF(L7:L7,">0",(L7*S7))

What I really want to do, is, if L7 has any value in it
then I want to multiply this value by the value that is in S7.
If there is no value (blank cell), then I want the cell that would contain
the product to remain blank.

L7 represents quantity
S7 represents Cost Per Unit
U7 represents Total

When I try to multiply L7 to S7, I get errors. I amtrying to avoid having
many cells with the 0 (zero) value

 

[Biff]

When I try to multiply L7 to S7, I get errors.

Do you mean that this formula gives you an error:

=L7*S7

Does it return a #VALUE! error? If so, that means one of or both values are
TEXT. Format those cells as GENERAL then select each cell and press function
key F2 then hit ENTER. That should fix the error problem (unless there are
unseen characters like spaces in one or both cells).

What I really want to do, is, if L7 has any value in it
then I want to multiply this value by the value that is in S7.

=IF(ISNUMBER(L7),L7*S7,"")

Biff

 

[Arvi Laanemets]

Hi

SUMIF sums up values in one range when condition in another range is true -
you have there not a range as 3rd argument at all, and more generally, you
have only single cells in your formula - so no need for summing at all.
=IF(OR(L7="",S7=""),"",L7*S7)