Multiple Countif or similar function

[TimE]

I need a formula that will look in column A and if a criteria is met,
then count column C for another criteria.

ex.

A C
1 PROJECT # STATUS
2 214 Complete
3 817 Scheduled
4 972 Scheduled
5 254 Complete
6 911 Refused
7 214 Complete
8 214 Refused
9 972 Scheduled

RESULTS

PROJECT # Complete Scheduled Refused
214 2 0
1
254 1 0
0
817 0 1
0
911 0 0
1
972 0 2
0


Am I going about this all wrong? Thank you for any help.

 

[Andy B]

Tim

One way is to use SUMPRODUCT()

=SUMPRODUCT((B2:B9=214)*(C2:C9="Complete"))
=SUMPRODUCT((B2:B9=214)*(C2:C9="Scheduled"))
etc

Andy.

 

[TimE]

Thank you Andy,

I should have included one more kink in it. The Status contains
"Complete, Refresh" etc. I actually need it to work with wildcards.
"*complete*" does not work with sumproduct. Any other ideas.

 

[Peo Sjoblom]

=sumproduct((isnumber(find("complete",myrange)))*(next_range=

 

[TimE]

Thank you Andy,

I should have included one more kink in it. The Status contains
"Complete, Refresh" etc. I actually need it to work with wildcards.
"*complete*" does not work with sumproduct. Any other ideas.