Posted to microsoft.public.excel.programming
|
|
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
|