View this video at https://macmost.com/summarize-data-easily-with-pivot-tables-in-numbers.html. You don't need to use formulas at all if you want to get totals, averages, counts and other summary information from your data. Just create a pivot table. Quick and easy.