Need to Look at Entire Column for ISBLANK

edited 05/23/24 in Formulas and Functions

This formula works for just the one row and returns either blank or the number inputted into the row where the formula resides:

=IF(ISBLANK(Rating@row), "", AVERAGEIF([Area of Review]:[Area of Review], "E-commerce", Rating:Rating))

But I need to look at the entire column called Rating to ignore those left blank and then average the entire row called Rating with the number inputted for the remaining items in the Rating column for my Area of Review.

Any suggestion would be greatly appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!