CountIF

[luisitocarrion1900]

Good Morning,

I have the below Formula that's not working for me

=countif('AI Extension',"D 2:D5000"=AIM"*'AI Extension', "I2:I5000"=Approved)

I need to count if the Sheet Named "AI Extension" Column D has the words "AIM" and Sheet Named "AI Extension" Column I has the words "Approved"

 

[Fluff]

How about
=countif('AI Extension'!D2:D5000,"*AIM*",'AI Extension'!I2:I5000,"Approved")

 

[tyija1995]

How about
=countif('AI Extension'!D2:D5000,"*AIM*",'AI Extension'!I2:I5000,"Approved")

This should be countifs not just countif, so that could be part the initial problem for the OP.

 

[Fluff]

Good spot, I was just correcting the construct & didn't notice the function was also wrong

 

[luisitocarrion1900]

So I corrected it to ad Countifs and it works the only problem is that I have AIM and AIM 2020 and is counting the AIM 2020 as well and I need it to count only the AIM

 

[Fluff]

In that case remove the asterix from the formula

 

[luisitocarrion1900]

I change it from "*AIM*" to "AIM" and it works now.

thank you

 

[luisitocarrion1900]

How about
=countif('AI Extension'!D2:D5000,"*AIM*",'AI Extension'!I2:I5000,"Approved")

Thank you so much, it works after adding countifs

 

[luisitocarrion1900]

This should be countifs not just countif, so that could be part the initial problem for the OP.

THank you for the Suggestion and it worked

 

[Fluff]

Glad we could help & thanks for the feedback