Sumproduct - Evaluate Difference

[polarisking]

I have two arrays and I'm subtracting one from the other, then testing each difference vs. a constant - =SUMPRODUCT(--(((B5:J5)-(B4:J4)))=0). When I step through the formula it's evaluating to the appropriate number of Trues/Falses, but it's not yielding the sum of the Trues, it's coming back 0. I'd prefer not to do an intermediate calculation then test the results vs. a single array.

Any help would be appreciated.

 

[SirJB7]

Hi, polarisking!
If you want to test the overall value resulting from the difference of each column elements, wouldn't it be the same doing this?:
=(SUM(B5:J5)-SUM(B4:J4))=0
Or do you want to retrieve an array like {TRUE;FALSE;TRUE;...}?
Regards!

 

[NARAYANK991]

Hi ,

Try this :

=SUMPRODUCT(--(((B5:J5)-(B4:J4))=0))

One of the parentheses in your formula is in the wrong place.

Narayan

 

[polarisking]

Narayan, once again you're dead on perfect! Thank you.