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.
Bookmarks