Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct Problem
I'm using Sumprduct to get a count of matching numbers in the
following two sets, going from A1:T1, A2:T2 4 12 14 15 16 20 21 22 28 29 31 36 43 47 49 58 59 60 66 69 5 7 9 13 16 21 27 30 31 37 41 43 45 48 51 52 56 59 64 67 the formula I'm using is =SUMPRODUCT(--(COUNTIF(A1:T1,A2:T2)0)) I keep getting an answer of 0, the answer should be 4 (16, 21, 31, 43 match) Can anyone see what I'm doing wrong?? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct Problem | Excel Worksheet Functions | |||
sumproduct problem | Excel Worksheet Functions | |||
SUMPRODUCT PROBLEM | Excel Worksheet Functions | |||
sumproduct problem | Excel Worksheet Functions | |||
sumproduct problem | Excel Worksheet Functions |