Formula for Star Rating that Ignores Blank Cells and O Values
I would like to Average the Star Ratings provided by seven people in the Rate Column.
The formula I have in the Rate Column is NOT ignoring blank cells or cells with a 0 value.
The image below shows the hidden columns that are connected to the formula.
=AVG([DH#]@row, [JH#]@row, [RH#]@row, [JM#]@row, [RF#]@row, [KM#]@row, [CY#]@row)
I am not super savvy with formulas. I appreciate any suggestions.
Best Answers

Personally, I would reorganize your columns to move all of the hidden columns to the right, so your numerical outputs would be one block from CY# to RH#.
Then, you can use
=AVERAGEIF([CY#]@row:[RH#]@row, >0)
With your current Sheet structure, something like the below might work but I haven't tested it.
=AVG(COLLECT(Cunesha@row:[RH#]@row, Cunesha@row:[RH#]@row, AND(ISNUMBER(@cell), @ cell>0))
👨🏼💻 Dan Palenchar  School of Sheets Solutions Consulting  Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
 🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
 ▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS  If you have a follow up response tag me @SoS  Dan Palenchar so I get notified of your reply!

@Dan Palenchar The first formula worked perfectly! I moved the columns CY# to RH# into a block and plugged in your formula. Thank you 🙌
💯 =AVERAGEIF([CY#]@row:[RH#]@row,
Answers

Personally, I would reorganize your columns to move all of the hidden columns to the right, so your numerical outputs would be one block from CY# to RH#.
Then, you can use
=AVERAGEIF([CY#]@row:[RH#]@row, >0)
With your current Sheet structure, something like the below might work but I haven't tested it.
=AVG(COLLECT(Cunesha@row:[RH#]@row, Cunesha@row:[RH#]@row, AND(ISNUMBER(@cell), @ cell>0))
👨🏼💻 Dan Palenchar  School of Sheets Solutions Consulting  Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
 🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
 ▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS  If you have a follow up response tag me @SoS  Dan Palenchar so I get notified of your reply!

@Dan Palenchar The first formula worked perfectly! I moved the columns CY# to RH# into a block and plugged in your formula. Thank you 🙌
💯 =AVERAGEIF([CY#]@row:[RH#]@row,
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!