count how many times does each month appear, when another column says X

[johnandrews]

See attached.

Raw data is B and C. I need to generate the numbers in G & H automatically, eg if B says 'person 1', how many times is each month mentioned? Then the boxes get filled in.

Would be much obliged.

[BBAUGH800]

Person 1 =countifs($b$2:$b$10,$g$1,$c$2:$c$10,f2)
person 2 =countifs($b$2:$b$10,$h$1,$c$2:$c$10,f2)

[BBAUGH800]

Is that what you are looking for?

[johnandrews]

Yup. Your reputation points are up, and thread marked SOLVED.

[johnandrews]

Hi, now I'd like to do the same, but for entire months - ie 1st to 30th January 2000. The first day of the month is in the same column. The last day is in the next column. I've tried to use

=COUNTIFS($B$2:$B$10,$H$1,$C$2:$C$10,MEDIAN(F2:G2))

Which is supposed to cover the whole month. Why isn't it working and what's the best solution?

[johnandrews]

=COUNTIFS($B$2:$B$10,$H$1,$C$2:$C$10,"<="&G3,$C$2:$C$10,">="&F2) in H2 works, but it's sort of lousy that MEDIAN doesn't.

[BBAUGH800]

Send the example sheet of what you are looking for.

[johnandrews]

Thanks, but it's already solved (see [SOLVED] before the forum title).