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

Count
 

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

"Jithu" wrote:

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

Count
 

Thanks Mike....

This is exactly what i want....

Thank you so much

JIthu

"Mike H" wrote:

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

"Jithu" wrote:

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