I want to calculate the number of actions closed and number of actions
pending as following. Column C I use Countif to solve. Column D and E???

Worksheet A is the summary of worksheet B
Column B Column C Column D Column E
(Name of Action needed) Total actions Actions closed Actions pending
Name A 3 ?
?
Name B 4 ?
?
Name C 3 ?
?
Name D 3 ?
?

Worksheet B
Column H Column K Column AC
(Actions Items) (Name for actions) (Action closed date)
Do A Name A 01 Jan 08
Do B Name A
Do C Name A 02 Jan 08
Do D Name B 01 Feb 08
..
..
..