palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
I have a row of data in the range L5:BI5
In CA5 I have a number
In BX5 I have another number
I'd like to count how many values in the initial range L5:BI5 exist between the lower value found in CA5 and the upper value in BX5.
I'm currently using the following ... =COUNTIF($L5:$BI5,AND(">="&$CA5,"<"&$BX5)) ... but it is returning zero.
Any thoughts would be greatly appreciated.
Very kind regards,
Chris
In CA5 I have a number
In BX5 I have another number
I'd like to count how many values in the initial range L5:BI5 exist between the lower value found in CA5 and the upper value in BX5.
I'm currently using the following ... =COUNTIF($L5:$BI5,AND(">="&$CA5,"<"&$BX5)) ... but it is returning zero.
Any thoughts would be greatly appreciated.
Very kind regards,
Chris