asked on # combining values in a formula

I have the following formula that works great but I need it to check for q1-2015 or q2-2015 can I do that in the same check

Report!T:T,"Q1-2015"

Report!T:T,"Q1-2015"

Microsoft Excel

=SUMIFS(Report!G:G,Report!L:L,"Civilian",Report!N:N,"0*",Report!N:N,"<>*06*",Report!D:D,"<>*Commit*",Report!U:U,"<>*Forecast*",Report!T:T,"Q1-2015")

I have to change this in a ton of places "the last part that is" so was hoping for an or type thing

I have to change this in a ton of places "the last part that is" so was hoping for an or type thing

well we cannot de-mistify things by bits. I can make up a VBA for you that will change the whole thing automatically but need you to post the workbook so I can study its extent.

But given what you have asked you could have something like this try if it works fine then will worry about changing all the formulas

=SUMIFS(Report!G:G,Report!L:L,"Civilian",Report!N:N,"0*",Report!N:N,"<>*06*",Report!D:D,"<>*Commit*",Report!U:U,"<>*Forecast*",Report!T:T,OR("Q1-2015","Q2-2015"))

gowflow

But given what you have asked you could have something like this try if it works fine then will worry about changing all the formulas

=SUMIFS(Report!G:G,Report!

gowflow

formula did not work

ok can you post the workbook ?

gowflow

gowflow

if column T = q1-2015, q2-2015, q3-2015 or q4-2015 and I get a quick formula I can place in another column to set the column to 20151H if T = q1-2015 or q2-2015 and 20152H if T = q3-2015 or q4-2015

Sorry don't understand your last post !

gowflow

gowflow

in my data tab...

I need a formula for column W which is currently blank that will set that column to:

20151H if column T = q1-2015 or q2-2015

20152H if column T = q3-2015 or q4-2015

I need a formula for column W which is currently blank that will set that column to:

20151H if column T = q1-2015 or q2-2015

20152H if column T = q3-2015 or q4-2015

Again can't you post your data ? much easier to understand.

gowflow

gowflow

Data is sensitive would take me about an hour to cleanup

ok so we need only to focus on the last post ?

I need a formula for column W which is currently blank that will set that column to:

20151H if column T = q1-2015 or q2-2015

20152H if column T = q3-2015 or q4-2015

or this is to be incorporated in the formula you first posted ?

and when you say I need a formula in W to

20151H if column T = q1-2015 or q2-2015

what do you mean by that ?

look at Col T if value is Q1-2015 or Q2-2015 then make the corresponding value in W 20151H ?

gowflow

I need a formula for column W which is currently blank that will set that column to:

20151H if column T = q1-2015 or q2-2015

20152H if column T = q3-2015 or q4-2015

or this is to be incorporated in the formula you first posted ?

and when you say I need a formula in W to

20151H if column T = q1-2015 or q2-2015

what do you mean by that ?

look at Col T if value is Q1-2015 or Q2-2015 then make the corresponding value in W 20151H ?

gowflow

yes exactly

Yes exactly what ? there are 2 questions in the post:

1) Is it to incorporate this W 20151H in the big formula ?

or

2) Simply create the new formula in Col W ?

gowflow

1) Is it to incorporate this W 20151H in the big formula ?

or

2) Simply create the new formula in Col W ?

gowflow

If you need option 2) in my previous post then put this formula in W1 and drag it down till end of data.

=IF(OR(LOWER(T1)="q1-2015",LOWER(T1)="q2-2015"),"20151H",IF(OR(LOWER(T1)="q3-2015",LOWER(T1)="q4-2015"),"20152H",""))

gowflow

=IF(OR(LOWER(T1)="q1-2015"

gowflow

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

means nothing !!!

can you post your formula ?

gowflow