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