0

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.

1 Answer 1

1

This formula works in Excel:

=SUMPRODUCT(B1:B500000+C1:C500000+D1:D500000+E1:E500000)/COUNT(B1:B500000)

enter image description here

1
  • Hm... And there isn't a way that would allow me to use the average function? Because the next thing I need are percentiles of these sums.
    – User1291
    Nov 28, 2016 at 16:54

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .