•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
AVERAGEIFS w multiple criteria in the same row, nonzeros
Hi all,
I am trying to create an average formula that looks at the header of each column (row 4) and selects based on that. Basically, is it's an "A" AND "F", I need it to average excluding any zeros. See above. Thanks for any help!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#row zero
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#cloud-based spreadsheet applications
#formula generator
#Excel alternatives
#AVERAGEIFS
#multiple criteria
#average formula
#nonzeros
#header
#column
#row 4
#excludes
#selects
#criteria