Just wondering if it is possible or which equation to use if I want to calculate certain values between them and return how many meet those criteria.
For example: I have values in multiple columns being entered as times from 900 to 1800. Now I want the COUNTIF to return the values which fall greater than 1415 but not greater than 1615.
Is this possible?
Currently this is what I have in place:
=COUNTIF(C10:AA10, ">1415")
The problem is I need it to only count values between 1415 and 1615. Not sure how to express this in the function.