SOLVED

Average

Brass Contributor

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.

Janedb_0-1585560141701.png

Janedb_0-1585560029169.png

 

 

 

5 Replies

@Janedb 

Did you try AVERAGEIFS() ?

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

Janedb_0-1585560947631.png

 

best response confirmed by Janedb (Brass Contributor)
Solution

@Janedb 

That's like

=AVERAGEIFS(<what to average range>, <dates range>, ">=" & $A$3, <dates range>, "<=" & $C$3)

 

@Sergei Baklan Thank you very much!! Its working :)

@Janedb , you are welcome, glad to help

1 best response

Accepted Solutions
best response confirmed by Janedb (Brass Contributor)
Solution

@Janedb 

That's like

=AVERAGEIFS(<what to average range>, <dates range>, ">=" & $A$3, <dates range>, "<=" & $C$3)

 

View solution in original post