What function to count matching columns

  • Thread starter Thread starter rchong
  • Start date Start date
R

rchong

Hi, I'm having a problem with figuring out how and what formula to use

For example, Column A has all the months on it and on column B ther
is either a more specific day for that month, or else it is blank.
would like Excel to be able to count how many column B's are filled i
for the specified month.

Thank you so very much
 
Try contructing a pivot table, under the "Data" pull down
menu. Follow the wizard and select the range of data in
column A & B. When constructing the layout, drag Col A
(Month) under ROW and Col B (Day)under COLUMN. Then drag
Col B (Month) again to DATA. It should say "Count of
Day". When you finish w/ the wizard you'll see a nice
summary of counts for every month. This is a great
function and you'll find it useful in many other
situations. Try it!!!
 
Back
Top