Hello .. Introduce yourself

[Hughes Solomon]

Hello !)))

 

[Durgaaprasadh]

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?

 

[vletm]

Durgaaprasadh​

This Forum is for Hello - Introduce Yourself.
You should open a new thread to correct Forum for Your Question.

 

[IPBR21054]

Just joined Hello from UK

 

[carpegc]

Hello to all; greeting for SC, I have been using Excel since Mid 90's, used VB6 and VBA a lot during this period, I have not taken any classes. Mostly self-taught, so not an expert by any means. I'm a previous drag racer that now enjoys my farm with horses.