Hi

i got some problem with excel.

My 1st spreadsheet - No of appointment
Date Status Country
--------------------------------------------------------------------
01-09-2006 Accepted ABC
01-09-2006 Accepted ABC
01-09-2006 Accepted ABC
01-09-2006 Accepted 123
01-09-2006 Accepted ABC
02-09-2006 Accepted ABC
02-09-2006 Accepted ABC

My 2nd spread sheet
Country Update

ABC 01-09-06 02-09-06
Appointment 4



Tis are roughly my spreadsheet , how am i able to count the number of
appointment on the 01-09-06 and computed on those the 2nd spreadsheet that
particular cell ??

Thank alot for the help .