One way:

=--(SUMPRODUCT(--($D$1:$D$10000<=D50),--($D$1:$D$10000=(D50-0.25)),
--($E$1:$E$10000=0),--($E$1:$E$10000<=0.3),--($E$1:$E$10000<""))0)

In article ,
Paul wrote:

I hope someone can help...
I can not seem to come up with a formula to do what I want.
I think the formula will contain "IF", "SUM", and "VLOOKUP", but I am not
100% sure. It could also be 'SUMIF'.
Here is the situation.
I have a column 'D' of time. The dates range for 2 months every 5 minutes.
I have a column 'E' of values (mostly between 0.0 and 0.3).
In column 'F' I would like to make a formula.
Let's say I am in cell F50...What I want the range to be is [D50:D50-0.25]
(6 hours prior)...I want to add the values in the 'E' column that fall within
this range I just stated.
Does that make sense?
I think if someone could help me with that, I could probably complete the
rest of the formula. The rest of the formula is: if the sum of the range is
equal to 0 then 0, if the sum of the range is 0 then 1. I have another
formula based on the 0 &1 result.
Thanks,
Paul