| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count a certain value
I want to count how many times the number 2 (for example) is in a column.
There must be some type of COUNT function (like count nonblank cells that contain the value "2", like an ACOUNT) but I can't find it and he help doesn't show me. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count a certain value
Try this:
=COUNTIF(A1:A100,2) or =COUNTIF(A1:A100,B1) where B1 contains the number you are interested in. Hope this helps. Pete chris wrote: I want to count how many times the number 2 (for example) is in a column. There must be some type of COUNT function (like count nonblank cells that contain the value "2", like an ACOUNT) but I can't find it and he help doesn't show me. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count a certain value
Perfect, thanks!
"Pete_UK" wrote: Try this: =COUNTIF(A1:A100,2) or =COUNTIF(A1:A100,B1) where B1 contains the number you are interested in. Hope this helps. Pete chris wrote: I want to count how many times the number 2 (for example) is in a column. There must be some type of COUNT function (like count nonblank cells that contain the value "2", like an ACOUNT) but I can't find it and he help doesn't show me. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula to count spinoffs | Excel Worksheet Functions | |||
| Subtotals by count | Excel Discussion (Misc queries) | |||
| Count consecutive dates only | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Linear Mode
