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

etc

 

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 *