COUNTIF / SUMPRODUCT problem

[office]

Can someone please tell me why the formula below won't count how many
occurrences of it there are.

=SUMPRODUCT((Sheet1!$B$3:$B$1000="1787")*(Sheet1!$F$3:$F$1000="2"))

All I want to do is count how many times 1787 appears in col B and a 2
appears in col F at the same time.
What am I doing wrong??

Thanx in advance

Rick

 

[Arvi Laanemets]

Hi

Are values in both columns really texts? When they are numbers, then
=SUMPRODUCT((Sheet1!$B$3:$B$1000=1787)*(Sheet1!$F$3:$F$1000=2))

 

[Max]

Try remove the quotes from "1787" and "2", viz.:
=SUMPRODUCT((Sheet1!$B$3:$B$1000=1787)*(Sheet1!$F$3:$F$1000=2))

The quotes are required only if the numbers in cols B & F are actually text,
not numbers.