Count Cells containing x but only under Column Heading "Contractor"

[yipppppppy]

Hi all,

The following formula works where it counts the number of cells containing x under column where the heading is Contractor. This column is in Column AO as per formula below but how can i modify the formula below so if someone moves the Contractor Column from Column AO to another column, the formula still works?

=IFERROR(COUNTIF('CL7'!AO:AO,"x"),"Error")

 

[Alex Blakenburg]

I think you must have edited your response after I first saw it.
Did the any of the suggestions work for you ?

If not the columns we are working on aren't exactly sensitive data, so blank out the other data and share the modified workbook via one of the sharing sites as previously suggested by @RICH937 and post the link to it here.
PS: Blank the rows don't delete the columns, we need everything to stay in it's current row/column position.

 

[Alex Blakenburg]

@kevin9999 & @RICH937 - if you interested to see how this was resolved, see here:

Count multiple conditions

Hi all, the following formula is returning 4 rows. The answer should be 1. I am trying to get the formula to only count a row where it meets all 3 conditions below 1) FY23 TP has an x AND 2) Portfolio is either DI, DD or Digital AND 3) Management Level is 7-Manager OR 6-Analyst...

www.mrexcel.com

 

[RICH937]

@kevin9999 & @RICH937 - if you interested to see how this was resolved, see here:

Count multiple conditions

Hi all, the following formula is returning 4 rows. The answer should be 1. I am trying to get the formula to only count a row where it meets all 3 conditions below 1) FY23 TP has an x AND 2) Portfolio is either DI, DD or Digital AND 3) Management Level is 7-Manager OR 6-Analyst...

www.mrexcel.com

GREAT WORK!