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.
