View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark Corbett Mark Corbett is offline
external usenet poster
 
Posts: 1
Default How to count certain values in a column

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