Countif

[sdrp]

Hi Guys,

Me again!

I'm trying to use the countif function, but with two contraints. Those being:

If a cell in column a = "test" and count the number of cells containing "test2" in column b.

I've tried to work around this, but can't get it to work,, any ideas?

Cheers

 

[dyarwood]

Two ways

use a countif(....) + countif(....)

or possibly use the and statement

countif(and(....,....))

let me know if they work

dyarwood

 

[SkipVought]

Hi,

Would something like this work?

=SUMPRODUCT((A1:A5="Test")*(B1:B5="Test2"))

Skip,

http://www.TheOfficeExperts.com

 

[SuicidED]

Using column c
=IF(A1="test",IF( B1 = "test2",1,0))
then sum the result

 

[sdrp]

lovely,,, cheers guys!!