Let's say I have some data on columns B through E that I want to average as follows:
- for each row: sum the four columns
- then take the average such sum
Do I have to get another column for the sum and then take the average of that column or is there a more direct approach? Because pulling =SUM(...)
down 500'000
rows does take a while.