Sum If "Date range"

  • Thread starter Thread starter Allan
  • Start date Start date
A

Allan

I track my consulting hours in an Excel spreadsheet. I
have made a summary page, and I would like to have it
automatically summarize how many hours/month I have noted.

I started with the following sumif function, as below,
where the function looks OVER one cell for the date.

=SUMIF(Record!B2:B58,A3,Record!J2:J58)

I need something more general: 5/*/2003 would be a great
date - if it would work. How can I have the above function
look up "all days" in a given month?
 
One way

=SUMPRODUCT(--(MONTH(Record!B2:B58)=5),Record!J2:J58)

assuming that dates are in B2:B58 and hours in J2:J58
will return hours in May
Now that will cost you one consulting hour from me <g>
 
Back
Top