Average if two conditions are met.

[levpn]

I am trying to get the average of column U if column AB says OCT and column AC says AVE. The AB section in the formula lights up as a range. The AC and U sections do not.

=AVERAGEIF(AND((AB4:AB849,"OCT"),(AC4:AC849,"AVE")),U7:U849)

[BadlySpelledBuoy]

Maybe this?

Please Login or Register  to view this content.

BSB

[yvonnecat]

Hi, I tried this formula, but I get a Div error due to the date.
I have list of different dates 01-Oct-18, 15-Oct-18 on left column and if I put one specific date in formula then it works, but partial date "oct" does not. Can you please help?

[Bo_Ry]

How about

=AVERAGEIFS(U7:U849,AB7:AB849,">=1OCT2018",AB7:AB849,"<=31OCT2018",AC7:AC849,"AVE")

[yvonnecat]

Still same error, thinking that date is formatted wrong. I have it custom d/mm/yy.
Would this affect calculation?
Solved it with & before the date(using a cell reference to the date range)
Eg "<="&$E$20,
Where cell E20 has the date 01-Oct-18 (first day of month)
And put end date in another cell
��Thank you

[Bo_Ry]

Maybe try keyin 1/10/18 at AB3

=AVERAGEIFS(U7:U849,AB7:AB849,">="&AB3,AB7:AB849,"<="&EOMONTH(AB3,0),AC7:AC849,"AVE")