• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hello .. Introduce yourself


I am working in a company in visakhapatnam. I enjoy creating excel reports. I learned may tips and tricks ,formulas. I have a problem in excel. I feel it can be solved here.

I want the sum in column C if the sum of column B and C is less than or equal to column A. I used the formula as =SUM(IF((C7:C9+D7:D9)<=A7:A9,D7:D9,0)). But i have to check this for the next also. Every time i need to add those columns separately to check them(=SUM(IF((C7:C9+D7:D9+E7:E9)<=A7:A9,E7:E9,0))). Can any one help me on this?