Count if type statement

[squeakums]

I wrote this statement which works if in column A:A it finds whats in cell C5, but is there a way to count all if cell A5 = "All" as well as my current formula, so countif , otherwise, if it's all, count all?

 

[Aladin Akyurek]

What is your current formula exactly?

 

[squeakums]

Oops, sorry I meant to leave that in there. Here it is:

=COUNTIFS('Monitoring Details'!I:I,"Missing AIT Registrations", 'Monitoring Details'!A:A,C5)

 

[Aladin Akyurek]

Oops, sorry I meant to leave that in there. Here it is:

=COUNTIFS('Monitoring Details'!I:I,"Missing AIT Registrations", 'Monitoring Details'!A:A,C5)

Are you after this?

=COUNTIFS('Monitoring Details'!I:I,"Missing AIT Registrations", 'Monitoring Details'!A:A,IF(A5="all","?*",C5))

 

[squeakums]

That helped, was hoping you new how to answer this one?

I'm having an issue here:

for those names that fall under P:P may not match F4 exactly, because of an initial in the name, how would I write this to count if name is similar when looking up on different tab?

=IFERROR(COUNTIFS('Issues w-out Action Plans'!K:K,"< 30",'Issues w-out Action Plans'!P:P,'MoEVM Summary Level'!F4),"0")

 

[Aladin Akyurek]

Care to post 10 rows from column P and what you have in F4?

 

[squeakums]

here's COLUMN p
MOEVM
BARNES, TOM
CLAIRE, ROSE
SMITH, JOHN
BOOTH, TIM
BOOTH, TIM
BOOTH, TIM
BOOTH, TIM
BOOTH, TIM
BOOTH, TIM
RUSS, JAMES
ICK, BOOM

COLUMN F4 IS A DROP DOWN LIST, SO THEY CHOOSE THEIR NAME FOR EXAMPLE

RUSS, JAMES

 

[squeakums]

The issue with this one was some of the names had initials in t he column P on the other tab, and the drop down list doesn't have their initials. But, on another note, I'm linking this to a SQL connection load, and it isn't pulling in any data anyways.. so cannot figure out why

 

[Aladin Akyurek]

What has sometimes intials: the P column or F4?