RANKAVG Function - exclude cell from range


I am trying to use the RANKAVG function but cannot figure out how to exclude a cell from the range selection. My equation is: =IFERROR(RANKAVG([Total Score]@row, [Total Score]$12:[Total Score]$77, 0), ""). I do not want to include cells [Total Score]24:[Total Score]26, [Total Score]39:[Total Score]41, [Total Score]52:[Total Score]54, or [Total Score]65:[Total Score]67 in the selection. Is there a way to exclude these cells from the ranking?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!