sum function help needed

**novice2430** · 12-10-2008, 05:18 PM

I'm using columns D and E.
I have one condition in each column, the condition in column D is triggered first then the condition in column E.
Is there a way to find the difference between the two numbers that show when each condition is triggered?

**NBVC** · 12-10-2008, 05:22 PM

Can you repeat that in better detail please?

What do you mean by "conditions".. formulas in those cells?

**novice2430** · 12-10-2008, 05:39 PM

I'm using a function with conditional formatting for column D, and another function with conditional formatting in column E. The condition in d is met first then the condition in e is met. I'm trying to have excel calculate the difference between the value in each cell once both conditions are met.
Can this be done?

**NBVC** · 12-10-2008, 05:40 PM

Still hard to understand...can you post a sample sheet showing what you are trying to do?

**novice2430** · 12-10-2008, 06:07 PM

I don't know how to add a sample sheet. What I'm working on isn't that important, so I'll work on it later. Thanks for giving it a go.

**NBVC** · 12-10-2008, 06:12 PM

When you click Reply, you will see a paperclip icon.. use that to attach an .xls or .zip file.

**NBVC** · 12-10-2008, 06:14 PM

It's probably as easy as creating an IF(AND()) formula that combines the conditions...

something like:

=IF(AND(Cond1,Cond2),do_this,do_that)

**novice2430** · 12-11-2008, 05:07 PM

I have attached a sample.

**novice2430** · 12-11-2008, 11:16 PM

Anyone know

**NBVC** · 12-11-2008, 11:41 PM

Can you please attach as a .xls file.. I don't have access to XL2007 on this computer.

**novice2430** · 12-12-2008, 12:37 AM

Here's the xls file

**NBVC** · 12-12-2008, 10:17 AM

I am afraid it is still not exactly clear what you want as a final result...

can you fill out the cell(s) you want results in manually.... so that I can see what you are expecting... and re-attach the sheet.

**novice2430** · 12-12-2008, 02:44 PM

Thanks for taking the time to help me!
Attached example.

**NBVC** · 12-12-2008, 03:32 PM

See attached...

I used 2 helper columns to assist in getting the final result the way you want it to appear... you can hide those columns, if desired.

In Helper column G, formula in G2 is

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear around the formula

in Helper column H, formula in H2 is

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER

In Column I, formula in I2 is:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER

You can then copy these formulas down the whole column.

**novice2430** · 12-12-2008, 04:10 PM

That looks real good! Excatly what I wanted.
Thanks again for your time and effort!
I do have one more question. When making a function an array, is there any way to ctrl+shift+enter the whole column instead of each cell seperately?