Find values bigger than and sum the resulting difference

Hello everyone,
I need your help once again.
I searched, tried countif sumif etc but could not find a way to join fomulas for the desired resault.
I have a row that contains numbers (these are hours)

I need in the last cell a formula that
finds the numbers bigger than 10 and give me the sum of those differences.
In this example it should be the number 6
9 8,5 12 10 14
Number 12 and number 14 exceeds number 10 and sums 2+4=6
Is this possible?
Thank you very very much.

What row? How many numbers?

Try this, assuming 6 numbers in row 1. You can put this formula in G1, then move it into any column to accommodate the necessary amount of data.

Formula:

Please Login or Register  to view this content.

Values as displayed

	A	B	C	D	E	F	G
1	9	8	5	12	10	14	6

Underlying formulas

	A	B	C	D	E	F	G
1	9	8	5	12	10	14	=SUMIF(A1:OFFSET(G1,0,-1),">10")-10*COUNTIF(A1:OFFSET(G1,0,-1),">10")

Or another one:

1) SUMIFS() to sum all values greater than 10 SUMIFS(A1:A5,A1:A5,">10")
2) COUNTIFS() to determine how many are greater than 10 COUNTIFS(A1:A5,">10")
3) The end result is equivalent to the modulo of the sum and the count times 10 =MOD(SUMIFS(...),10*COUNTIFS(...))