CODEWITHSUNDEEP
algorithmexcelexcel-formula
adam saparudin
adam saparudin

Reputation: 11

Summing diagonals and retrieve the maximum value among them

I have this example data:
SO19478826 question example

I need to get maximum value as from summing groups of values in this data. What I want to sum is:

First count from A1. In this case, I have 42.
Second, I just can go down and lower right diagonal.
Last, I must reach the end (line 25).

I need to get the maximum value among all diagonal summations.

How to do it in Excel?

Upvotes: 0

Views: 175

Answers (1)

lori_m
lori_m

Reputation: 5567

Assuming your range is named A and starts at A1, try entering this formula in a free cell:

=MAX(MMULT(N(OFFSET(A,MOD(ROW(A)+COLUMN(A)-2,ROWS(A)),COLUMN(A)-1)),ROW(A)^0))

Upvotes: 2

Related Questions