Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMPRODUCT Error
Good afternoon,
I have the formula ... =SUMPRODUCT(COUNTIF(E10:J10,N10:S10)) .... which I have copied down in column "T" some 2,500 cells which should always return the value 6. Unfortunately the formula only works on about 80% of the formulas although I know for a fact that the two sets of numbers match EXACTLY and are values as opposed to text etc. The only difference with the two sets of numbers to match is the first six are not sorted numerically where as the second set of numbers are. Thanks in advance, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct DIV/0 Error | Excel Worksheet Functions | |||
Sumproduct error | Excel Programming | |||
SUMPRODUCT #VALUE! Error | Excel Worksheet Functions | |||
SUMPRODUCT Error | Excel Programming | |||
SUMPRODUCT #N/A error | Excel Discussion (Misc queries) |