ExcelBanter - Count value if not Number

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Count value if not Number (https://www.excelbanter.com/excel-programming/373616-count-value-if-not-number.html)

Nigel

Count value if not Number

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

Max

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

Jay

Count value if not Number

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

All times are GMT +1. The time now is 10:23 AM.