Excel if formula vs, google sheets if formula

I have the following formula which works great in google sheets but gives me a "Value" error in Excel (same values), can you please help me with finding the way to get around the "Value" error in exc...

excel

Formulas and Functions

mtarler
Aug 14, 2020
rhc002 The problem is that you are adding TEXT ("") to NUMBERS.
Try replacing the "" in each IF statement with 0.
Or try this formula instead:
=SUMPRODUCT($D$19:$D$23*$A$19:$A$23*($E$19:$E$23="x"))

mtarler

Silver Contributor

Aug 14, 2020

rhc002 The problem is that you are adding TEXT ("") to NUMBERS.

Try replacing the "" in each IF statement with 0.

Or try this formula instead:

=SUMPRODUCT($D$19:$D$23*$A$19:$A$23*($E$19:$E$23="x"))

rhc002
Copper Contributor
Aug 14, 2020
mtarler Thank you, both solutions work
🙂

Forum Discussion

Excel if formula vs, google sheets if formula

Resources