How do I get a cell to count values from a list dependent on anoth

[John]

My first tab is a summary and looks something like this
A1 B1 C1
D1
Status Total D
F
New 5 2
3
Analysis 2 0
2
Analysis Completed 3 3
0

So, the information in the B column is being pulled from
=COUNTIF(STATUS;Analisys!BA1)

The information in the columns C and D is dependent on the list STATUS but
is being inputted manually at the moment

The STATUS list has 5 returns of new. Contained within this tab where the
list STATUS is found the column adjecent to this has either D or F in the
field.

eg.

new D
new F
new D
new F
new F

I am after a formula that will update this on the summary page.

Thanks to anyone who can help.

 

[Roger Govier]

Hi John

In cell C2
=SUMPRODUCT((Status!$A$2:$A$100=A2)*(Status!$B$2:$B$100=C$1))
Copy across to D2
Copy C22 to C3:C4

Cell B2=C2+D2