Forum Discussion
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...
Are you sure it's not working? The error message is one pertaining to dividing by zero. It looks to me as if there are no rows that meet the full set of criteria, so the divisor is zero which generates that error. There are times when an error message comes about because the formula IS working.
- Hi, thanks for the information. I have had a further look and implemented some dates which are above my set dates (1/12/2022), then some below. However i appear to still be getting an error, when there is data available for both. Any thoughts?
Many thanksAre you still getting the same error? It wasn’t the date criterion that wasn’t met; it was one or two of the others
- 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.
