Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
count each cell that have a number and take that number and count. | Excel Discussion (Misc queries) | |||
Number count - postcodes and need to count the numbers of tim... | Excel Discussion (Misc queries) | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Count number of times a specific number is displayed in cells | Excel Programming |