I have a formula like this =COUNTIF('Program Schedule Loader TCs'!N2:N9994,"PASS") Now i want to have a formula that always references to column 'N' on the mentioned sheet even after inserting new columns.

1 Answer

You were nearly there - you just need to wrap the range with INDIRECT() (remember to add quotes to the range as well).

=COUNTIF(INDIRECT("'Program Schedule Loader TCs'!N2:N9994"),"PASS")

This will ALWAYS reference column N, even if by inserting new columns there is no data in column N.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy