I have attached a file. In sheet "1" and Sheet "2" I have several names in column A and random "X" in columns B thru V
In sheet "Curtis" I want to add all the Xs in curtis' row. I know I can do this like this: =COUNTIF('1'!B7:V7,"<>"&""
) Since Curtis in on row 7 and it works fine.
Now if I "Sort" the table on sheet "1" it messes all up.
How can I make it so if I sort the tables the equations still work??
I hope this makes sence.