I have a sheet with a list of names split into 8 columns. Inbetween each of these is a further 3 columns containing other pieces of numerical data. I am currently counting how many times a certain name occurs in all the columns by using COUNTIF(F1,AJ100,"name"). This works but it is counting across the entire field, eg 32 columns. I could do COUNTIF(F1,F100,"name")+COUNTIF(K1,K100)+ etc etc, but is there a more elegant way?