circular reference

[breilly00]

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

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​

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?

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​

 

[Fluff]

If your trying to get a count, try

=COUNTIFS(data25!$B$2:data25!$C$35000,">="&A6,data25!$B$2:data25!$C$35000,"<="&B6)

 

[breilly00]

sending porkchops and beer. Works like a charm.

 

[Fluff]

You're welcome & thanks for the feedback.