SUMPRODUCT working in argument window, but returns error in cell

[improvet]

Hi!

I have two rows with values and I'm using sumproduct to subtract the two. However I also need the formula to ignore empty fields and don't do the substraction if the lower field is empty. It seems to work when i use the insert function window, but once the formula is applied to a cell it returns the error #VALUE


=SUMPRODUCT(IF(ISEMPTY(A2:E2);0;A2:E2-A1:E1*50))

The answer should be 1,5*50-60=-15 and then ignoring C1.

And indeed thats what it says in insert formula window:

Any ideas?

 

[improvet]

Try to use ISNUMBER, not ISBLANK, because it would be appropriate for numeric data.

Yeah you're right, added it, here's the final formula:
=SUMPRODUCT(--ISNUMBER(A2:E2);A2:E2-A1:E1*50) (also removed the 1- in first matrix as to not invert the true/false)