in cell AD put formula countif(C7:AC7,"x")
cheers
Jay

"Nigel" wrote:

I have a spreadsheet where various cells in row 7 columns c to ac have a
value of X

Is it possible to count the number of X's in that row and put the total in
column AD

Thanks