Sumproduct based on Date range
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
|