Sumproduct based on Date range

  • Thread starter Thread starter MIchel Khennafi
  • Start date Start date
M

MIchel Khennafi

Good morning to All of you

Situation:
- I have dates like "From" and "To" in A1 and B1
- In C3, I have the formula =+SUMPRODUCT((names=B6)*Hours)/8
- The ranges "names" and "hours" refer to a list where I have people name
and number of hours.

I would like to change the fornula =+SUMPRODUCT((names=B6)*Hours)/8 so that
I only do the SUM of the rows in the list that are WITHIN the date range in
A1 and C1. What should I do to only sum those row which date are in between
A1 and B1 Please?

Michel
 
=SUMPRODUCT(--(names=B6),--(dates>=A1),--(dates<=B1),Hours)/8

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top