•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.
Our take
To calculate the average of cells in column AW while ignoring zeros and errors, and only including those rows where column AL contains a specific year, you can use the AVERAGEIFS formula. This formula allows you to set multiple criteria. Begin by specifying the range in column AW, then set conditions to exclude zeros and errors. For the year in column AL, ensure you specify the exact year rather than using a wildcard. This approach will help you achieve your desired result effectively.
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]
Read on the original site
Open the publisher's page for the full experience
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