Count numbers or dates based on a condition - Microsoft Support
Alternately, you can use SUMPRODUCT too. Example. Note: Youll need to adjust these cell formula references outlined here based on where and how you copy these examples into the Excel sheet. See examples of how to use worksheet functions to count numbers or dates that fall within a range in Excel.
more
|