What I want to do is fairly complicated.

I have Sheet 1 with data on,
then Sheet 2 with the figures of this data.

On Sheet2;
In one column im using COUNTIF to count Column A on Sheet 1 (which is
a date) to see how many were entered on this date.
On sheet 1 i have another column which is kind of like a tick column,
where some are ticked to see if this query has been resolved.
I want to use a countif to count these 'ticks' (which are the letter
'a') but to only count them on the date given.

IE. 2 Example lines from Sheet 1..
DATE | TITLE | TICK |
31/3/2008 | COMPANY A | |
31/3/2008 | COMPANY B | a |
28/3/2008 | COMPANY C | |

On Sheet 2 this would show as...
DATE | INPUT | TICK |
28/3/2008 | 1 | |
31/3/2008 | 2 | |

With the cell for the input being;
=(COUNTIF(Sheet1!B:B,A34))
[with the references being relevant to be spreadsheet]

I want the tick box to show how many have 'a' present in that column,
creating this..
DATE | INPUT | TICK |
28/3/2008 | 1 | |
31/3/2008 | 2 | 1 |

I tried using countif again, but it counts ALL the ticks for every
date. This isnt what i want.
Can anyone help??