sum if columns, but only the value if bellow or above

rebreanradu

New member
Joined
Feb 2, 2017
Messages
11
Reaction score
0
Points
0
Excel Version(s)
2019
hello,
i think i'm doing something wrong, as i have 6 columns with different numbers from 0-20.
i want to add a formula to calculate from all the cells, if the cell value is above 10 or below 10, but only the difference. for better understanding i attach the file.
the values represent a tire depth of a truck. i want to see in the end, how many tires are above 10 and with what amount. also, how many are below 10, and what is the value


can somebody help me pls ?
 

Attachments

  • Book1.xlsx
    9.1 KB · Views: 12
This should get you the values above 10mm

=SUMPRODUCT(D5:I5-10,--(D5:I5>10))
 
thx but seam's that is missing something as i get an error when presing ENTER
 
sorry, my bad, i was missing (;).
it is good. works.
 
Back
Top