How to count certain values in a column

[Guest]

I'm designing a spreadsheet where column B contains the month and column C
contains a numerical value. Could anyone out there suggest a formula that
only counts the values in Column B for the month contained in column C.

B C
April 1
April
April 3
April 1
May
June 1
June 1
June 1
July 3

 

[Guest]

I should have written "only counts the values in Column C for the month
contained in column B."

 

[Guest]

I am presuming you meant sum vlaues in col c for month in col B:

=SUMIF(a1:a24,"jan",b1:b24)

Hope this is what you were after.

 

[Guest]

Nav

Thanks, that's exactly what I wanted. Very helpful.

Mark
------------------------------------------------