Sumproduct question?

  • Thread starter Thread starter capt
  • Start date Start date
C

capt

Hi,
I have the following formula:

=SUMPRODUCT(--($A$10:$A$5000>=Sheet2!$P$3),--($A$10:$A$5000<=Sheet2!$R$3),--($B$10:$B$5000=N3),--($E$10:$E$5000<TIME(41,40,0)),$D$10:$D$5000)

What its suppose to do is to filters a criteria (col B) between two dates
(col A), it then totals all the hours under 41 hours and 40 minutes.
I get a figure but not the correct one.
Can anybody help?
 
Hi,

In your formula, the reference dates used to filter are located in :
- Sheet2!$P$3
- Sheet2!$R$3

HTH
 
Hi Carim,
Yes, dates are located in:
- Sheet2!$P$3
- Sheet2!$R$3
Column E: keeps a running total for that month, so that I can find the point
where 41 hours 40 minute is reached.
 
Column "B" is where I put the criteria.
Cell "N" is where I select a criteria to filter.
Column "D" is the hours.
 
Back
Top