Add one more condition as

=SUMPRODUCT((B2:B11=3)*(B2:B11<=3.9)+(C2:C11=0))

If this post helps click Yes
---------------
Jacob Skaria


"GoBucks" wrote:

Sorry edit to to previous post:

How would you write the formula if the criteria for
column B is =3 and <=3.9 along with column C=0??

"GoBucks" wrote:

Thank you for the help!! How would you write the formula if the criteria for
column B is =3 and <-3.9 along with column C=0??

"T. Valko" wrote:

I assume the "-" means the cell is empty?

=SUMPRODUCT(SIGN((B2:B11=3)+(C2:C11=0)))

I don't see a single 0 in
--
Biff
Microsoft Excel MVP


"GoBucks" wrote:

I am looking to get a formula that count the number of rows that match some
criteria. The sample table is listed below. I would to have a formula
calculate the # of rows in which values in column B =3 along with values in
Column C = 0

ID RATING AMOUNT formula match
00304 4.0 (5.0) x
00299 2.5 - x
00069 2.5 2.0
01380 4.0 - x
01729 3.0 - x
01783 2.5 - x
01934 2.0 (1.0)
01901 3.8 (1.0) x
01482 3.0 (1.0) x
02076 2.5 (1.0)

COUNT 5 3 7


B=3 = 5 rows
C=0 = 3 rows

But if you combine both criteria, there are 7 rows that match. I 'm having a
difficult time figuring our how to write the formula for this. Any
suggestions will be much appreciated.