Forum Discussion
MichalK55
Sep 06, 2023Copper Contributor
how to count cells with one number between two different numbers
Hello, In column D, I need to count the occurrence of the value 5 that appears between the values 18 and 19. I don't want to count any other value 5 in this column. Can anyone advise how to do this ...
PeterBartholomew1
Sep 06, 2023Silver Contributor
HansVogelaar
Sep 06, 2023MVP
I'm sorry, I must be dense. I thought the OP wanted to count 5's in between 18 and 19. 17 doesn't come into it as far as I can tell.