Jan 11 2023 04:59 PM - edited Jan 12 2023 04:55 PM
Hi All,
I have a set of data which I wish to show the average value for. There is a couple criteria so i am using averageifs to find the average value. However i wish to include a criteria to include values after a certain date. I have tried to use the formula similar to sumifs, however it appears to not be working.
I have attached the excel spreadsheet i am working on, looking to update the formula is column T. Does anyone happen to know how this can be done?
Greatly appreciate any assistance.
Many thanks
Jan 11 2023 07:43 PM
Jan 11 2023 10:20 PM
Jan 11 2023 11:53 PM - edited Jan 11 2023 11:53 PM
Are you still getting the same error? It wasn’t the date criterion that wasn’t met; it was one or two of the others
Jan 12 2023 04:51 PM