# Moving the columns halfway

1. ## Moving the columns halfway

That was a very bad explanation...

I have the following formula in A1:

=IF(AND(PQQ!E28="Fail",ITT!E24="Fail"),"Fail",SUM(D4:D8))

When I drag it to the right (A2 and so on), I need it to change to =IF(AND(PQQ!G28="Fail",ITT!G24="Fail"),"Fail",SUM(E4:D8)) - hence the SUM bit just goes by 1 column to the right as normal. But the AND bit goes by 2 columns - from E to G.

I know there is some king of COLUMN formula but not sure how to write it down here.

Would be grateful for the advice.

Thank you.  Register To Reply

2. ## Re: Moving the columns halfway

=IF(AND(PQQ!E28="Fail",ITT!E24="Fail"),"Fail",SUM(D4:D8))
=IF(AND(PQQ!G28="Fail",ITT!G24="Fail"),"Fail",SUM(E4:D8))

What exactly is in those SUM columns?
Did you notice that your adjusted SUM range went to E4:D8? Was rgar supposed to be E4:E8 or D4:D8?
What headings do those columns have?
Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.  Register To Reply

3. ## Re: Moving the columns halfway

I suppose you want this

Formula:  `Please Login or Register  to view this content.`

Copy to forward (for other columns)

See the file  Register To Reply

4. ## Re: Moving the columns halfway

Sorry for a late reply due to weekend.

Thank you Jose, that is exactly what was needed!

Sorry FD for not coming back and clarifying, the SUM formula should have just moved by one column as usual, hence would have been E4:E8. But Jose has helped with the right formula.

Thank you all once again!  Register To Reply

5. ## Re: Moving the columns halfway

You are welcome.   Register To Reply

6. ## Re: Moving the columns halfway

Thanks for the feedback   Register To Reply