1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

AVERAGEIFS w multiple criteria in the same row, nonzeros

https://preview.redd.it/2rv31ly50hpg1.png?width=1101&format=png&auto=webp&s=57995ed19b856c2b5a36b92e7a39fd2737fd7744

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!

submitted by /u/squatonmeplz
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#row zero
#rows.com