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

Sumproduct based on Date range
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MIchel Khennafi" wrote in message
...
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