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.