Counting Problem

Hi all,

hope you can help me with the workbook attached.
I have a database with more than 22k records, most of them with zero values. Each project is classified under a certain status.
I would like to count how many different projects in each status are contributing to deliver the amount displayed in column D and E.
If I use COUNT, Excel is counting the number of rows, not the different projects.

My aim would be to have
- X different projects are contributing to Y $ M in status A
- N different projects are contributing to R $ M in status B
etc

See attached workbook

THANKSExcel.xlsx

you can use countif, for example:
=countif(D4:D22000,<>0)
or countifs to include what is in column C.