LinkBack URL
About LinkBacks
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)
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)
Maybe this?
Formula:
Please Login or Register to view this content.
BSB
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?
How about
=AVERAGEIFS(U7:U849,AB7:AB849,">=1OCT2018",AB7:AB849,"<=31OCT2018",AC7:AC849,"AVE")
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
Last edited by yvonnecat; 01-24-2019 at 10:23 PM.
Maybe try keyin 1/10/18 at AB3
=AVERAGEIFS(U7:U849,AB7:AB849,">="&AB3,AB7:AB849,"<="&EOMONTH(AB3,0),AC7:AC849,"AVE")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks