Good evening, Thank you in advance for any assistance you can provide.
I am trying to sum (countif) the total amount of matching items from one sheet, if they match a certain timeframe range (e.g. one week, one month, ALL) on the same sheet, to the matching item on the recall sheet.
And this is the separate sheet [let's call it SHEET 2] collecting responses that I want to tally according to their date and equaling the value on [SHEET 1] in column A.
I need the SHEET 1 formula for each AREA to search say B:K on SHEET 2 and total the amount for each AREA on SHEET 1 for the last 7 days, last month and all time.
I was able to make something like this work before but now trying to piece together code and formula from multiple tutorials I am lost!
Please help thank you so much!