Need formula combine 2 columns into one column

[jackson_hollon]

Hello,

I need a formula to combine column F & G into one column. I have attached a file here. And the screenshot below.

If column D less or =4, then I need to use the formula from F, if greater than 4, then needs to use the formula in G. Each formula pull the data from a sheet. Column F & G will be deleted afterward.

Thanks for the help.

Tests.PNG

[AliGW]

I think you are going to kick yourself in a minute:

=F2+G2

[jackson_hollon]

AliGW,

No, I know your formula. I am talking about I need a formula to combine 2 formulas together. I do not know how to say it. If you look at my file, you will see each formula pull the data from a sheet.

column F & G will be deleted.

[elayaz]

Hi Jackson,

Check if this works

Please Login or Register  to view this content.

[AliGW]

Sorry - I misread your post. Looks like you have a solution, though.

Here's another:

=IF(C2="Net Income", 0, IF(LEFT(D2,1)>4, SUMIF(BS!$C:$C,Con!D2,BS!$D:$D), 0))+IF(LEFT(D2, 1)>3, SUMIF(QTD!$C:$C,Con!D2,QTD!$D:$D), 0)

[jackson_hollon]

elayaz,

The formula works great. Thanks.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[jackson_hollon]

AliGW,

Your formula works perfectly. Thanks.

[AliGW]

It's just the same as the simple one I offered above, just using the formulae.

[jackson_hollon]

AliGW,

I do not know why when I combined my 2 formulas into one, it doesn't work. I do not know what I have done wrong.

[AliGW]

Does not work in what way?

Just copy paste the first, then +, then the other.

[jackson_hollon]

AliGW,

You just taught me a way how to combine 2 formulas together. Thanks.

[AliGW]

This will only work if the two values can be summed together. It's not the usual way, but just happens to work in this particular case.