I am searching a sheet named data25 for certain values and counting the number of times they occur
A sample of some rows in sheet data25 is below
In my results sheet I have the following starting at row 5. I am searching the first detected and last detected to see if either of the cells should be counted for the range of Low MPH or High MPH. In the count cell, I have this formula...=COUNTIFS(data25!$B$2:data25!$C$35000,">="&A6,data25!$B$2:data25!$C$35000,"<="&B6)-SUMPRODUCT(--(data25!$B$2:data25!$B$35000>=A6),--(data25!$B$2:data25!$B$35000<=B6),--(data25!$B$2:data25!$B$35000=$C$2:$C$35000))
and I get a circular reference and a value of 0 in the cell.
What do I have to change?
A sample of some rows in sheet data25 is below
Date/Time | First Detected Speed | Last Detected Speed |
2/1/2021 0:37 | 64 | 50 |
2/1/2021 4:10 | 37 | 28 |
2/1/2021 4:11 | 19 | 26 |
2/1/2021 5:29 | 14 | 25 |
2/1/2021 5:37 | 36 | 33 |
2/1/2021 5:44 | 52 | 46 |
and I get a circular reference and a value of 0 in the cell.
What do I have to change?
L-MPH | H-MPH | COUNT |
25 | 34 | 0 |
35 | 44 | |
45 | 54 | |
55 | 64 | |
65 | 74 | |
75 | 84 | |
85 | 94 | |
95 | 104 | |
105 | 114 | |
115 | 124 | |
125 | 134 |