Lookup? countif?

  • Thread starter Thread starter ~Jeff~
  • Start date Start date
J

~Jeff~

I have a table:
Column A has dates (format example: Thursday, September 23)
Column B has vacation hours
Column C has sick time hours

I have tally table started:
Column A has the months (January, February, March, etc)
Column B has vacation hours
Column C has sick time hours

For the tally table I would like to count up all hours that fall in that
month for vacation hours and the same for sick time.

Anyone know the formula to do this?

Thanks
 
Possibly
=SUMPRODUCT(TableRange*(MONTH(TableDates)=TestMonth))

Where TestMonth = the numerical value 1-12 of the month in Col A of Summary.
If that month has been entered as a date and formatted to show just the
month then MONTH(TestMonth) will return that number.
TableRange is the range of figures you want to add up, and TableDates is the
range of dates.

You may need to test the year as well, of course. That can be adapted.
 
Back
Top