Hi,

Can onyone help me on how to create AVERAGEIFS with multiple criteria in the same criteria range

e.g. January, February, March, etc.

Sub a()
Dim WhatToAvg As Range, Criteria1_Range, Criteria2_Range As Range
Dim calculate As Variant
 
Set WhatToAvg = Range("H524:IW581")
Set Criteria1_Range = Range("H515:IW572")
Set Criteria2_Range = Range("H519:IW576")

calculate = Application.WorksheetFunction.AverageIfs(WhatToAvg, Criteria1_Range, "Less Complex", Criteria2_Range, "January")

MsgBox Format(calculate, "0.00")
End Sub