Requesting some help with regards to a vlookup formula

Hello, I'm trying to figure out a formula that will allow me to search for a text result within a range of cells between a date that is specified in another cell and will give the value of the amount of rows that contain said value.

Sounds a little complicated but I basically have a sheet that has first column specifying date and second column specifying a text in this case being the letter A or B

What I'd optimally like to do is set a value of a cell to be a date range and then have the formula in a different cell reference that date range, find the range in the first column, then look at the second column to see what rows have a or b letters in them and then calculate the amount of rows with a or b


I've been trying to string something together with vlookup plus row and date but it hasn't been going well.

Any help would be greatly appreciated. Thank you

The date range can be split up into two cells quite easily so that the difference calculations can be done. The only thing that needs to remain is the original date of action. I am optimally looking for the least amount of values so that I can split all up the results and then add them to another sheet as needed. Essentially I'd prefer a formula just for A and another just for B.

I added the file to my attachments let me know if youre able to get it. And thank you so much for your help.

wow that's working perfectly. Yes the time slots have to be within the same date range that is selected for A and B. Also if I wanted to specify the same formula to located locations I can just switch the value of the cell that its referencing however the only problem I am receiving is that is will only look for exactly the name as written and not act essentially like a 'contains' filter. I can create duplicates of the formula into multiple cells and then have the reference cell be multiple variations of the search term so that it covers all the possible variations of the same location.

Essentially if someone doesn't fully fill out the address and puts in Arthur st instead of Arthur street west or puts in Arthur st W instead of fully filling out the name.

I sincerely appreciate the help and would love to get a better understanding of what the variables are meaning inside of the formula as well as donating somehow for the help.

I created another sample sheet that has a little more of a breakdown. I am trying to be able to breakdown street, repair, a/b, time, and amount between dates and for addresses that may not be exact.

Try this in K13 and copy down

Formula:

Please Login or Register  to view this content.

See the file

My apologies glenn, that post was in reference to Jose, I will update here once the formula meets my needs and then ask for the explanation when appropriate.

Thank you again for all of your help.

Originally Posted by Jman2102

My apologies glenn, that post was in reference to Jose, I will update here once the formula meets my needs and then ask for the explanation when appropriate.

Thank you again for all of your help.

Hi

I suppose the summary I made in the file that attached, clarifies the way to make filters. See the file