I thought this would be easy enough to do but after a couple of days messing around on and off with formula's i am no closer to getting the result i want:
I have 2 rows of cells being compared using the formula:
=IF(E5>F5,"1",IF(E5<F5,"2", IF(E5=F5,"X")))
This works fine but then my next formula is suppose to count if this matches another range of cells (e.g. cells I-L 5:16), i tried:
=SUMPRODUCT((K5:K16=M5:M16)*1)
But this only works for the x's unless i use the abs() function which throws an error any time I have x's.
I am at a bit of a loss now so any assistance would be kindly received
Bookmarks