Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Counts Cells
Can anyone tell me the formula to have Excel count cells? If I have 100
different values or names, can I put a formula in a cell to count the number values or names? Thanks for your help!! |
#2
|
|||
|
|||
Go to XL help and read up on COUNT, COUNTA, and COUNTIF.
HTH Jason Atlanta, GA -----Original Message----- Can anyone tell me the formula to have Excel count cells? If I have 100 different values or names, can I put a formula in a cell to count the number values or names? Thanks for your help!! . |
#3
|
|||
|
|||
=counta(a1:A100)
will count the number of cells with something in them (values or formulas) =count(a1:a100) will count the number of cells containing numbers. Debra Dalgleish has a bunch of tips for counting/summing at: http://www.contextures.com/xlFunctions04.html and http://www.contextures.com/xlFunctions01.html WZabrouski wrote: Can anyone tell me the formula to have Excel count cells? If I have 100 different values or names, can I put a formula in a cell to count the number values or names? Thanks for your help!! -- Dave Peterson |
#4
|
|||
|
|||
-----Original Message----- Can anyone tell me the formula to have Excel count cells? If I have 100 different values or names, can I put a formula in a cell to count the number values or names? Thanks for your help!! . Use "COUNTA" insterd of "COUNT". This will count all non blank cells. Mal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
Formatting cells in Excel for certain Values to appear certain Col | Excel Worksheet Functions | |||
Excel Charts and cells | Charts and Charting in Excel | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
How do I "Wrap Text" & "Autofit" within Merged Cells in Excel? | Excel Worksheet Functions |