Need data count using formula in a different tab to give me the result

[starpupil]

i am looking to get a formula which will help me get a count of number of times the event has occured
example

This data is found in Tab 1
[TABLE="class: grid, width: 12, align: center"]
<TBODY>[TR]
[TD]date
[/TD]
[TD]Name
[/TD]
[TD]Result
[/TD]
[/TR]
[TR]
[TD]3/1/2012
[/TD]
[TD]Anna
[/TD]
[TD]Pending
[/TD]
[/TR]
[TR]
[TD]3/1/2012
[/TD]
[TD]John
[/TD]
[TD]Closed
[/TD]
[/TR]
[TR]
[TD]3/1/2012
[/TD]
[TD]Sam
[/TD]
[TD]Reassinged
[/TD]
[/TR]
[TR]
[TD]3/1/2012
[/TD]
[TD]John
[/TD]
[TD]Reassinged
[/TD]
[/TR]
[TR]
[TD]4/1/2012
[/TD]
[TD]Anna
[/TD]
[TD]Pending
[/TD]
[/TR]
[TR]
[TD]4/1/2012
[/TD]
[TD]Anna
[/TD]
[TD]Pending
[/TD]
[/TR]
[TR]
[TD]4/1/2012
[/TD]
[TD]Anna
[/TD]
[TD]Closed
[/TD]
[/TR]
[TR]
[TD]4/1/2012
[/TD]
[TD]Anna
[/TD]
[TD]Closed
[/TD]
[/TR]
[TR]
[TD]4/1/2012
[/TD]
[TD]Sam
[/TD]
[TD]Reassinged
[/TD]
[/TR]
</TBODY>[/TABLE]



The result should give me this in Tab 2

[TABLE="class: grid, width: 50, align: center"]
<TBODY>[TR]
[TD][/TD]
[TD]3/1/2012
[/TD]
[TD]3/1/2012
[/TD]
[TD]3/1/2012
[/TD]
[TD]4/1/2012
[/TD]
[TD]4/1/2012
[/TD]
[TD]4/1/2012
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Pending
[/TD]
[TD]Closed
[/TD]
[TD]Reassinged
[/TD]
[TD]Pending
[/TD]
[TD]Closed
[/TD]
[TD]Reassinged
[/TD]
[/TR]
[TR]
[TD]Anna
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sam
[/TD]
[TD][/TD]
[TD][/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD]1
[/TD]
[/TR]
</TBODY>[/TABLE]

I tried to different variation of =countif; then i do not know how to put the date variable into account
please help,

much appreciated

 

[Aladin Akyurek]

Excellent !! thank you so much !! you are a life saver

You are welcome. Thanks for providing feedback.

 

[Aladin Akyurek]

Excellent !! thank you so much !! you are a life saver

You are welcome. Thanks for providing feedback.