Hi All,
I am trying to use sumproduct instead of countif and despite searching the past entries, i'll still a bit clueless.
I want to count the number of instances where the cell in column A is a "12" and the value in column B is a "F".
However, when I enter the formula below, it produces a zero. When i use it on purely text (e.g. if A = Fred and B= Mary) it works, but when i mix a number with a text value, i don't get the result i hoped for (i.e. 2, using the data below).
=SUMPRODUCT((F8:F16="12")*(G8:G16="m"))
Can anyone see what i'm doing wrong and how it can count combinations of different cell formats (text, numbers, dates etc).
12 M
13 F
12 M
14 M
01 F
Cheers,
John Mc
Bookmarks