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 |