View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Count value if not Number

In AD7:
=COUNTIF(C7:AC7,"X")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nigel" wrote in message
...
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