Forum Discussion
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 ...
To count the occurrence of the value 5 that appears between the values 18 and 19 in column D, you can use the following formula:
=COUNTIFS(D:D,5,D2:D100,">18",D2:D100,"<19")
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark them as helpful!
This will help all forum participants.