Nav

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

Mark
------------------------------------------------
"Nav" wrote:

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.


"Mark Corbett" wrote:

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


"Mark Corbett" wrote:

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