Jan 31 2022 10:44 AM
I feel like there should be a simple solution to this problem, but I haven't been able to crack it.
I have a table that includes a list of equipment, and the dates they were used. I want to be able to specify a range of dates, and then be able to see how often a particular piece of equipment was used in that time frame. I'd like to type the start date in one cell, the end date in another, and have the frequency fill in automatically when I choose different ranges.
Thanks for any help!
Jan 31 2022 10:58 AM
SolutionIn G7:
=COUNTIFS($A$2:$A$500,">="&$G$3,$A$2:$A$500,"<="&$H$3,$B$2:$B$500,F7)
Adjust the ranges if needed, then fill down.
Jan 31 2022 11:01 AM
Jan 31 2022 10:58 AM
SolutionIn G7:
=COUNTIFS($A$2:$A$500,">="&$G$3,$A$2:$A$500,"<="&$H$3,$B$2:$B$500,F7)
Adjust the ranges if needed, then fill down.