COUNTIF function with two conditions

[dwain]

Hi

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

Please Login or Register  to view this content.

, 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]

Hi,

Try this:

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

[arthurbr]

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

[dwain]

Thanks guys! Much appreciated!

[arthurbr]

Here is a nice explanation on this fucntion