COUNTIF / SUMPRODUCT problem

  • Thread starter Thread starter office
  • Start date Start date
O

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
 
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))
 
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.
 
Back
Top