Forum Discussion

Iron Contributor

Jan 12, 2023

Help to find average of values before/after a certain date

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

averageifs help.xlsx24 KB

averageifs help 2.xlsx19 KB

average help 3.xlsx35 KB

Formulas and Functions

Gold Contributor

Jan 12, 2023

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

calof1

Iron Contributor

Jan 13, 2023

Hi thanks for the message. I have gone through and checked each stage of the other criteria. I can been able to validate the other two, just the final one which includes date is not working. I have been using 1/2/2023 as a test case in the latest spreadsheet. So i have an answer on either side of the date.