sum few cells with if condition

i would like to sum cell range without extra column or manually type + when they have condition. Here example


sum of a, b, c, d, values if 


a is value 10 if exceeds 100

b is value 10 if exceeds 100



the idea is to eneter number in a, b, c columns and if it is over 100 to have 10 as in number and one cell to conbine all 10s


Please help



By: Silvi

Leave a Reply

Your email address will not be published. Required fields are marked *