stmoritz

asked on

# #NUM error with excel SUMPRODUCT formula

On sheet "fetch" in the yellow coloured cells I would like to calculate the total balances for the respective types (A, B, ...) from sheet "modified" with sumproduct. But I get the #NUM error. How to fix it? (I don't want to use sumif).

thanks.

ee21.xls

thanks.

ee21.xls

SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
Could be to do with closed workbooks?

...Good point, Rory....:)

ASKER

big thaaaanks!

(btw, yes rory!)

(btw, yes rory!)