Calculating values but ignoring if it's a higher value than the previous one

There are instructions at the top of the page explaining how to attach your sample workbook.

As you offered no explanation of the required calculation I am "guessing" from what I recall from your first post:

=SUM(IF(B2:G2-C2:H2>0,B2:G2-C2:H2,0))

Enter with Ctrl+shift+Enter

This is the formula from the second row:

=(B2-C2)+(C2-D2)+(D2-E2)+(E2-F2)+(F2-G2)+(G2-H2)

Where:

B2=100
C2=97

D2=65
E2=223

F2=211
G2=150
H2=120

However, the (D2-E2) must be ignored in the formula as the E2 is greater than D2. The total should be 138 or (3)+(32)+(0)+(12)+(61)+(30)

This is just a simple template in which I have only 7 columns but in fact they can be hundreds or thousands. I hope this makes sense.

Thanks

Alternatively, =SUMPRODUCT((B2:G2-C2:H2)*(B2:G2>C2:H2))

@josephteh: I started down the SUMPRODUCT route but it must have been late in the day so it didn't click!

@anik9: use Joseph's SUMPRODUCT solution!

@ JohnTopley.. haha.. it's 1pm Singapore time. I am well awake! My suggestion is to use both formulas. One main, and one as a checksum. That's what I usually do when I got multiple solutions.

@joseph: about 06:30 am here in the UK ... and on the forum: what a sad man I am!!!

No no no.. you are nothing like a sad man. You are a giant in Excel. And it's your passion in helping fellow forum members like myself that helps me improve my Excel skills tremendously! You have helped me solved many problems. For that, I am forever grateful.

Thanks guys for the help. Is it going to work with hundreds or thousands of columns and rows, whatever is in the spreadsheet basically, as I see it's limited to what's in the test file? I'm trying to find the logic in order to explain to a friend who may be able to write a script based of this logic. Thanks

Yes, both formulas are going to work perfectly for hundreds and thousands of columns and rows, as long as you cover the columns correctly.