COUNTIF function with two conditions

**dwain** · 09-25-2008, 07:48 AM

Hi

I need to know a way of doing a COUNTIF function with two conditions inside it, my current formula is

=COUNTIF('Master data'!BN$6:BN$156,CONCATENATE("<=",$B19))

, and I want to add another check to range 'Master data'!P$6:P$156 = "someText". I only want it to be counted if both conditions are true.

I hope this makes sense,

Thanks in advance

Dale.

**sweep** · 09-25-2008, 08:03 AM

Hi,

Try this:

=SUMPRODUCT(('Master data'!BN$6:BN$156<=$B19)*('Master data'!P$6:P$156 = "someText"))

**arthurbr** · 09-25-2008, 08:04 AM

Hi and welcome to the board
try =sumproduct((range1=condition1)*(range2=condition2))

This kind of question has already been asked many times on the forum. Forum's Search should yield lots of results)
Cheers