Thread: Count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jithu Jithu is offline
external usenet poster
 
Posts: 36
Default Count

Hi,

My spreadsheet contains data in two columns A&B
Col A Col B
January Sick
January Sick
January Vacatioon
Februay Sick
February Sick

i want a formula that will give the counts like
January&sick = 2
February&sick = 1

Please help...thanks in advance fot your time....

Jithu