Hi,
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?