Count 1 column based on condition of another

[SorenN]

I think the answer to my question is something to do with COUNTIF although I can not figure this out.
The spread sheet lists various items we are track when they were purchased, purchase type, delivery status etc.
I need help figuring out how many items with purchase type "ECAT" have been delivered.
Here is the formula I am trying and can not make work: =CountIF(Table2[Purchase Type/Source]= "ECAT", COUNTA(Table2[Delivery Complete]))
I look forward to getting help and learning more of Excel!
Thanks,
Soren

Sample data:

Purchase Type/Source	Purchase Order #	Delivery Complete
PCAC	583-A10047	Yes
PCAC	583-A10038	Yes
ECAT
Micro	583-Q15468
ECAT	583-B10050	Yes

 

[Joe4]

Try using COUNTIFS instead of COUNTIF, that allows you to check more than one criteria (Purchase Type and Delivery Complete).
See: MS Excel: How to use the COUNTIFS Function (WS)

 

[Fluff]

How about

=CountIFS(Table2[Purchase Type/Source],"ECAT",Table2[Delivery Complete],"Yes")

 

[SorenN]

Thanks that did the trick! I have not used the CountIFS before. I will explore more of how it works.
I have a tangential question, how would I count the number of purchase orders for the specific purchase types? I tried this formula although the results returned were not correct. =COUNTIFS(Table2[Purchase Type/Source],"Micro",Table2[Purchase Order],"*5")

 

[Fluff]

Try

=COUNTIFS(Table2[Purchase Type/Source],"Micro",Table2[Purchase Order],"<>")

 

[SorenN]

Thanks Fluff, what does help!
What does <> tell Excel to do? I am not familiar with what <> tells Excel to do, is it away to ignore empty cells?

 

[Fluff]

is it away to ignore empty cells?

Yes it will count blank blank cells in the 2nd range.