| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
count number of cells
What is the formula to count the number of cells that start with a particular
character? What I really want to do is count how the number of cells in a column that start with a through e. I have tried several things but can't quite come up with the magic formula. thanks for your help. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
count number of cells
=COUNTIF(A1:A20,"A*")+COUNTIF(A1:A20,"B*")+COUNTIF (A1:A20,"C*")+COUNTIF(A1:A20,"D*")+COUNTIF(A1:A20, "E*")
-- David Biddulph "tagout" wrote in message ... What is the formula to count the number of cells that start with a particular character? What I really want to do is count how the number of cells in a column that start with a through e. I have tried several things but can't quite come up with the magic formula. thanks for your help. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
count number of cells
The COUNTIF Function should be used for that.
When using the Countif: Countif(Select all the cells you want to review, What is the criteria you want to count, e.g: "e*") Hope this helps, Vicente "tagout" wrote: What is the formula to count the number of cells that start with a particular character? What I really want to do is count how the number of cells in a column that start with a through e. I have tried several things but can't quite come up with the magic formula. thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the number of cells | New Users to Excel | |||
| How do I count cells that contain a number of charctors. | Excel Worksheet Functions | |||
| Count cells that have a number 0 | Excel Discussion (Misc queries) | |||
| Count Number of Different Cells | Excel Worksheet Functions | |||
| count number of cells | Excel Worksheet Functions | |||
Linear Mode
