Hi Jeffrey

The formula is the same in each row, its a simple countif of open & closed form Column A (Tab Status) and Column B (P1, P2 & P3 possibilities).
The values in A & B of Tab Status will vary as the project progresses and (hopefully) the number of items open will decrease with those closed increasing. Similarly the number of P1's, P2's & P3's will fluctuate on a daily basis.

The purpose of tab Data is to record this on a daily basis to show the burndown. I 'simply' want the row which corresponds to each day in tab data to automatically update.

That make sense??