Formula
 

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?
--
mother of 4

Formula
 

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 /


On Apr 14, 9:24 am, mygirls2_ae wrote:
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?
--
mother of 4

Formula
 

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").




"mygirls2_ae" wrote:

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?
--
mother of 4

Formula
 

Tyla and Art

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


"Tyla" wrote:

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 /


On Apr 14, 9:24 am, mygirls2_ae wrote:
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?
--
mother of 4

Formula
 

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

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mygirls2_ae" wrote...
Tyla and Art

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