Excel's COUNTIFS() function is flexible enough to handle different ranges and data types. In Count the number of Excel records that fall between two dates, I used the COUNTIFS() function to count the ...
We would say that this ID has been active every day from 6/1/16 up to and including 9/30/16. I need to be able to count how many distinct IDs were active on any given day, and also be able to average ...