count if

[stebrownsword]

Hi

help with this formula please?

=COUNTIF(ZERO!BH:BH,"Y",ZERO!J:J,"*Agency*)
Basically I only want it to count if Column “ZERO!BH:BH” hasa ""Y in cell and if Column “ZERO!J:J”includes the word Agency in the column

The above formula, excel says there’s too many arguments?

Thanks in advance

 

[steve the fish]

More than one criteria means you need countifs

=COUNTIFS(ZERO!BH:BH,"Y",ZERO!J:J,"*Agency*")

 

[stebrownsword]

thanks, so simples when you know lol