SOLVED

Formula Help, Reference a range of cells conditional on dates

%3CLINGO-SUB%20id%3D%22lingo-sub-3094608%22%20slang%3D%22en-US%22%3EFormula%20Help%2C%20Reference%20a%20range%20of%20cells%20conditional%20on%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3094608%22%20slang%3D%22en-US%22%3E%3CP%3EI%20feel%20like%20there%20should%20be%20a%20simple%20solution%20to%20this%20problem%2C%20but%20I%20haven't%20been%20able%20to%20crack%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20table%20that%20includes%20a%20list%20of%20equipment%2C%20and%20the%20dates%20they%20were%20used.%20I%20want%20to%20be%20able%20to%20specify%20a%20range%20of%20dates%2C%20and%20then%20be%20able%20to%20see%20how%20often%20a%20particular%20piece%20of%20equipment%20was%20used%20in%20that%20time%20frame.%20I'd%20like%20to%20type%20the%20start%20date%20in%20one%20cell%2C%20the%20end%20date%20in%20another%2C%20and%20have%20the%20frequency%20fill%20in%20automatically%20when%20I%20choose%20different%20ranges.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22BenLarson_0-1643654625563.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343989i1957F3EA6674CBA6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22BenLarson_0-1643654625563.png%22%20alt%3D%22BenLarson_0-1643654625563.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3094608%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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. 

BenLarson_0-1643654625563.png

 

 

Thanks for any help!

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@BenLarson 

In 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.