Mar 30 2020 02:17 AM - edited Mar 30 2020 02:22 AM
Average if condition of criteria between two dates are met in excel.
I am trying to work out average consumption if the totals are between two dates. The consumption is posted on another tab of the same spreadsheet.
Mar 30 2020 02:37 AM
@Sergei Baklan Yes, but I want the date to be referred to between A3 & C3. It only allows me to make the date part of the formula (2010,01,01) which is not easy if you are working on a spreadsheet for a full year.
Mar 30 2020 02:42 AM
SolutionThat's like
=AVERAGEIFS(<what to average range>, <dates range>, ">=" & $A$3, <dates range>, "<=" & $C$3)
Mar 30 2020 02:42 AM
SolutionThat's like
=AVERAGEIFS(<what to average range>, <dates range>, ">=" & $A$3, <dates range>, "<=" & $C$3)