| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting number of X's in a column
I need to sum up the number of "Xs" in a column. I would be extremely
grateful if someone could help me with the formula. I cannot seem to get one to work. We are using Excel 2003. Thank you. -- Susie Harris Operations Manager Environmental Education Association of Washington |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Counting number of X's in a column
=COUNTIF(A:A,"X")
-- HTH RP (remove nothere from the email address if mailing direct) "Susie Harris" wrote in message ... I need to sum up the number of "Xs" in a column. I would be extremely grateful if someone could help me with the formula. I cannot seem to get one to work. We are using Excel 2003. Thank you. -- Susie Harris Operations Manager Environmental Education Association of Washington |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Counting number of X's in a column
Bob,
Ohmigosh!!!! That is just too simple. Thank you so much. I was waaayyy too stuck on an if statement. -- Susie Harris Operations Manager Environmental Education Association of Washington "Bob Phillips" wrote: =COUNTIF(A:A,"X") -- HTH RP (remove nothere from the email address if mailing direct) "Susie Harris" wrote in message ... I need to sum up the number of "Xs" in a column. I would be extremely grateful if someone could help me with the formula. I cannot seem to get one to work. We are using Excel 2003. Thank you. -- Susie Harris Operations Manager Environmental Education Association of Washington |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the last number in a column | Excel Discussion (Misc queries) | |||
| Program Column B to record numerical range based on number in colm | Excel Discussion (Misc queries) | |||
| look up number in column | Excel Worksheet Functions | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Column number of last column containing a number | Excel Worksheet Functions | |||
Linear Mode
