Hello everyone.
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!
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!