Nov 18 2021 10:43 AM
Nov 18 2021 11:00 AM
=ROUND(SUM(IF(A7:A21>AVERAGE(A7:A21),A7:A21)),0)
For example you can calculate the rounded sum of all numbers that are above the average. Enter formula with ctrl+shift+enter if you don't work with Office365 or 2021.