I am having a problem with the following SUMPRODUCT formula:

=SUMPRODUCT((Data!$AV$2:$AV$5000>F72)*(Data!$AV$2:$AV$5000<G72)

Where:

Data! AV2:AV5000 = a time (calculated by a formula) and formatted in [mm]:ss

F72 = 0:00 and the cell is formatted as [mm]:ss

G72 = 02:00 and the cell is formatted as [mm]:ss

I am trying to calculate how often the answer displayed in data!av2:av5000 is greater than zero, but less than 2 minutes.

As of now, the formula above is returning all instances of data!av2:av5000 being greater than zero only.

Any help would be greatly appreciated as always.

Thanks!