Help with AVERAGEIFS with last row

[maym]

Hi all

I am having trouble with the below formula and referencing the last row:

Range("E16").Formula = "=AVERAGEIFS($H$22:$H$" & lastrow & ", $W$22:$W$" & lastrow & "=1,$H$22:$H$" & lastrow & ","">=""&E12,$H$22:$H$" & lastrow & ",""<=""&F12)"

I get 'Application-defined or object-defined error. Does anyone know where I'm going wrong?

Thanks

[TMS]

Try:

Range("E16").Formula = "=AVERAGEIFS($H$22:$H$" & lastrow & ", $W$22:$W$" & lastrow & ",1,$H$22:$H$" & lastrow & ","">=""&E12,$H$22:$H$" & lastrow & ",""<=""&F12)"

That is, change "=1" to ",1"

[maym]

thank you TMS I couldn't quite figure it out.

[TMS]

You're welcome.

Not easy, just looking at it. I first put a space in front of the equals sign (in the formula) to see what was generated. Then copied that, without the space, and put it in a cell to see what error message Excel generated, rather than VBA. Then you see that it's "too few parameters" which gives you the clue.

[maym]

Good feedback. Thank you again

[TMS]

You're welcome. Thanks for the rep.