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:
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 |