| 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 | |||
Hybrid Mode
