Help - Formula Not Working

[Delta Star]

I'm using the formula below to total some hours but it does not work:-

=SUMPRODUCT(--(Filter2!$E$2:$E$179=$A1),--(Filter2!$A$2:$A$179>=Calcs!IC$6),--(Filter2!$A$2:$A$179<=Calcs!IC$7),Filter2!$G$2:$G$179)

If I remove this section --(Filter2!$A$2:$A$179<=Calcs!IC$7) it does but then the criteria have changed so the results are incorrect.

I have checked the data and everything is correct, so I can only assume that the formula is wrong.

 

[Aladin Akyurek]

I'm using the formula below to total some hours but it does not work:-

=SUMPRODUCT(
    --(Filter2!$E$2:$E$179=$A1),
    --(Filter2!$A$2:$A$179>=Calcs!IC$6),
    --(Filter2!$A$2:$A$179<=Calcs!IC$7),
    Filter2!$G$2:$G$179)

If I remove this section --(Filter2!$A$2:$A$179<=Calcs!IC$7) it does but then the criteria have changed so the results are incorrect.

I have checked the data and everything is correct, so I can only assume that the formula is wrong.

The formula has the correct syntax...

Note that:

10 >= 6

10 <= 8

would not count as 10 being between 6 and 8. You have
probably something like the foregoing, that is:

While some cells are satisfied thru...

Filter2!$A$2:$A$179>=Calcs!IC$6

but fail satisfy:

Filter2!$A$2:$A$179<=Calcs!IC$7

Would you check the data for this eventuality that is against
your expectations?