software

Good morning to All of you

Situation:
- I have dates like quot;Fromquot; and quot;Toquot; in A1 and B1
- In C3, I have the formula = SUMPRODUCT((names=B6)*Hours)/8
- The ranges quot;namesquot; and quot;hoursquot; 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),--(datesgt;=A1),--(dateslt;=B1),Hours)/8

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;MIchel Khennafiquot; gt; wrote in message
...
gt; Good morning to All of you
gt;
gt; Situation:
gt; - I have dates like quot;Fromquot; and quot;Toquot; in A1 and B1
gt; - In C3, I have the formula = SUMPRODUCT((names=B6)*Hours)/8
gt; - The ranges quot;namesquot; and quot;hoursquot; refer to a list where I have people name
gt; and number of hours.
gt;
gt; I would like to change the fornula = SUMPRODUCT((names=B6)*Hours)/8 so
that
gt; I only do the SUM of the rows in the list that are WITHIN the date range
in
gt; A1 and C1. What should I do to only sum those row which date are in
between
gt; A1 and B1 Please?
gt;
gt; Michel
gt;
gt;