•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Average cells in a column and ignore those with 0 and #VALUE, but only if I different column contains a certain year.
Back again because everyone was so helpful!
I'm trying to Average cells in row AW, while ignoring Os and errors, while also only doing that row if column AL contains a certain year. I think that makes sense?
I know it needs to be an AVERAGEIF formula, but when I do "*2026*" as the Criteria, before even attempting the >0, the formula breaks.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#row zero
#formula generator
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#financial modeling with spreadsheets
#AVERAGEIF
#average
#ignore
#cells
#errors
#column
#row
#criteria
#year
#0
##VALUE!
#AW