Formula

[Guest]

I have a huge spreadsheet that has an "x" in columns of things that need to
be done. Is there a way to have each x total at the bottom of the column?

 

[Tyla]

You might exlore the "COUNTIF" function. For instance, if I wanted to
know the number of cells in A1 thru A100 which had an "X" in them, I
could use "=COUNTIF(A1:A100,"X")

/ Tyla /

 

[Guest]

I'm really not sure what you're asking, and you might need to explain a
little more.

But for now, let me guess... You have a bunch of rows and in each row some
of the columns have an "x" in them. At the bottom of each column you want to
count the number of "x's" in that column. If that's what you're trying to
do, then suppose one of those columns is "B" and has x's in rows 1 through
1000. In B1001 you could put: =COUNTIF(B1:B1000,"x").

 

[Guest]

Tyla and Art

Thank you very much. The "COUNTIF" function worked. I had never used that
before. Thank you again.

 

[David McRitchie]

Glad the solutions provided by Tyla and Art worked
for you. Thought the following might be of further
help in finding and using additional Worksheet Functions
you are not familiar with. In addition to Excel's own Help.

For help in finding and using formulas you might take a look at
Excel Function Dictionary , by Peter Noneley
with 150 example functions and formula.
http://www.hoffits.com/xlfdic/index.html

You might find my page also of interest concerning
Summarizing Data Examples (an Overview)
http://www.mvps.org/dmcritchie/excel/sumdata.htm



"mygirls2_ae" wrote...