Higher values in Col A than Col B, sum rows with the higher value and show difference

Hi Community,

I have two columns of values, I need to know the sum of all the rows where Column A has a higher value than Column B.
If Column B is higher then ignore.
There could be 100+ rows of values and I need to apply this to multiple workbooks, but each workbook will have it's own total.

Any help is appreciated.
Thanks.

Thanks for the reply Glen, not quite as it's needed.

I only need to know the total value of the rows that have a higher value in Column A than in Column B
In the attached sheet, I have two examples.
One set is showing the total of column A, Column B and the higher value total of each row.
Then Highest values minus Column B totals. In the example, Highest values 30 - Column B 26 = 6

Then other is showing the total of only where Column A is higher than Column B (Actually in Columns F & G) showing 6.

I need to get 6 from this data.

Also, there will be other info in between the two columns such as peoples names, preferences, etc.

Or try this in C12:

=SUM(IF(A1:A10>=B1:B10,A1:A10,B1:B10))

in G12:

=SUMPRODUCT((F1:F10>G1:G10)*(F1:F10-G1:G10))

Thanks for the solutions. It is working perfectly.