Excel Wizards I have a dumb question

[preshi]

I want to have a box that adds up the amount of x's in a column.

I can't figure it out for the life of me... Can anyone help?

THANKS

 

[castlegazer]

If you are refering to the actualy term "x" then you need to use COUNTIF as the function. It will ask you two questions when you use the function, the first will bethe range which you will define by highlighting the column with the x's in it. HTe next question will be the criteria which you will define as x. It will then give you the number of x's in that column.

If you want to count a series of numbers you will use the function SUM, and again highlight the column and it will sum the entire column or defined area for you.

Hope that helps. If not I may need some more info to be of further help.

 

[KathyTX]

The function =COUNTA(data range) will give you the number of non-blank cells in a range.

So, if Column D is empty except the cells where you've put an X, the function =COUNTA(d1 : D500) would return the number of non-blank cells between D1 and D500.

Does that make sense?

 

[preshi]

Thank you both!! I know how to do numbers but the x's were making me nuts!!!

 

[iNTeNSeBLue98]

I use this formula on my Ebay spreadsheet to calculate the number of items listed ...

=COUNT(A2:A17)

It calculates the number of cells that contain an item number. I use the same formula for the column contain Final bids to keep track of the number of items sold (well, that closed with a winning bid ).