self-paced learning path
1 Topic
Subtracting from the addition of 2 specific cells with a given condition / given conditions.
Hello. I was messing around in Excel and I want to subtract from the addition of one specific cell to another, only if the product is larger than a given criteria. So e.g. B1=1500 , C8 = 5692 , condition = ">6400" So if possible, I would want to write something like =SUMIF((B1+C8),">6400",-6400) or something like that. I have 3 main problems: 1. The SUMIF function apparently only works for ranges of data, not specific cells. In this case, I only need 2 specific cells, i.e. B1 and C8. Am I using the wrong function then? 2. I don't know how to include the -6400 part if the conditions are met. How do I do that? 3. In the future, if let's say I would like to add more conditions, how do I introduce more conditions? Is it even possible in the first place? If someone can kindly advise me, I would appreciate it very much, thank you...Solved2.9KViews1like11Comments