**Question description:**

*This user has given permission to use the problem statement for this blog.*

I want to sum the two highest consecutive values in a row of numbers. What formula should I use? Thank you.

Solved by G. E. in 24 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
29/11/2017 - 11:51

Hello, welcome to Got it pro

User
29/11/2017 - 11:52

Hello

User
29/11/2017 - 11:52

I am trying to sum the two highest consecutive values in this row.

Excelchat Expert
29/11/2017 - 11:52

I didn't get you

Excelchat Expert
29/11/2017 - 11:53

what do you mean by two highest consecutive ?

User
29/11/2017 - 11:54

I mean two consecutive numbers (side by side), that when totaled, are higher than any other two consecutive numbers

Excelchat Expert
29/11/2017 - 11:54

ok

Excelchat Expert
29/11/2017 - 11:54

Please wait

User
29/11/2017 - 11:55

Sure

Excelchat Expert
29/11/2017 - 11:57

F3 is 0

Excelchat Expert
29/11/2017 - 11:57

right?

User
29/11/2017 - 11:57

Yes

Excelchat Expert
29/11/2017 - 11:58

ok

Excelchat Expert
30/11/2017 - 12:01

done

Excelchat Expert
30/11/2017 - 12:01

See, cell C5

Excelchat Expert
30/11/2017 - 12:02

it's the maximum sum

Excelchat Expert
30/11/2017 - 12:04

there?

Excelchat Expert
30/11/2017 - 12:05

hello?

User
30/11/2017 - 12:05

I don't think that's it unfortunately. The sum of the two consecutive numbers for C3 and D3 would be different. Can I show you what I mean in a long hand example

Excelchat Expert
30/11/2017 - 12:06

yes, it is

Excelchat Expert
30/11/2017 - 12:06

C3+D3 is written in D4

Excelchat Expert
30/11/2017 - 12:06

then D3+E3 is written in E4

Excelchat Expert
30/11/2017 - 12:07

E3+F3 in F4

Excelchat Expert
30/11/2017 - 12:07

similarly, ll values

User
30/11/2017 - 12:07

C3 + D3 should be 259,722

Excelchat Expert
30/11/2017 - 12:08

done now

Excelchat Expert
30/11/2017 - 12:09

See cell C5 and C7

User
30/11/2017 - 12:09

I see, let me take a look

User
30/11/2017 - 12:11

Great, I can see it responding now

Excelchat Expert
30/11/2017 - 12:11

ok

Excelchat Expert
30/11/2017 - 12:11

Have a great day

Excelchat Expert
30/11/2017 - 12:11

:)

User
30/11/2017 - 12:11

I'll sign up for an account. This was really helpful. Appreciate your expertise!

Excelchat Expert
30/11/2017 - 12:12

Thanks and Welcome!

Excelchat Expert
30/11/2017 - 12:12

Please leave your valuable feedback :)

Excelchat Expert
30/11/2017 - 12:12

You may close the session now form above :)

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*