Sumproduct if other cell has text

[TrojanMan]

Hi all! Love the forum and always get my questions answered through a search, but cannot seem to find an exact answer for what I'm looking for this time.

I want to do a sumproduct of the values in columns A*B only if there is text in column C (not blank).

I've tried a bunch of variations but I can't seem to get it to work without getting the VALUE error.
I've checked and there is no issues when I sumproduct(A,B) but I can't seem to get anything to work when I want to include the reference to C.

Please advise!

 

[Marcelo Branco]

Welcome to Mr Excel forum

Try something like this - adjust the ranges
=SUMPRODUCT(A2:A100,B2:B100,--(C2:C100<>""))

M.

 

[MBierce]

Hi TrojanMan.

Is the below what you're looking for? It summed the cells for me into D2 when I tested it.

=IF(ISBLANK(C2),"",SUMPRODUCT(A2:B2))

 

[Dave Patton]

same as above

 

[TrojanMan]

Welcome to Mr Excel forum

Try something like this - adjust the ranges
=SUMPRODUCT(A2:A100,B2:B100,--(C2:C100<>""))

M.

That worked perfectly, thank you so much, and even more so for the super quick response. You guys rock!

 

[Marcelo Branco]

You are welcome. Glad to help.

M.