Count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi,

This should do what you want:-

=SUMPRODUCT((A1:A20="January")*(B1:B20="Sick"))

To make it easier to manage put the months jan - dec in (say) c1 to c12 and
change the formula to

=SUMPRODUCT((A$1:A$20=C1)*(B$1:B$20="Sick"))

Put it in D1 and drag down to D12

Mike
 
Back
Top