| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering data
Try,
=COUNTIF(A1:A100,"A") The "A" could be a cell reference where that cell contains what you are trying to count. =COUNTIF(A1:A100,B1) Mike "Brie" wrote: i want to filter and count the data in 1 column 4 eg. i have 3 different data, i.e. A, B and C. Total A+B+C = 10 entries. A=3 entries, B=4, C=4. how to generate this data using formula or filter? many thx. brie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filtering data
wow, thx Mike! it works!
do you know if i can put "A=3" instead of just the total count? brie "Mike H" wrote: Try, =COUNTIF(A1:A100,"A") The "A" could be a cell reference where that cell contains what you are trying to count. =COUNTIF(A1:A100,B1) Mike "Brie" wrote: i want to filter and count the data in 1 column 4 eg. i have 3 different data, i.e. A, B and C. Total A+B+C = 10 entries. A=3 entries, B=4, C=4. how to generate this data using formula or filter? many thx. brie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering out data | Excel Discussion (Misc queries) | |||
| Help with Filtering data | Excel Discussion (Misc queries) | |||
| filtering data | New Users to Excel | |||
| Filtering data | New Users to Excel | |||
| Data Filtering | Excel Discussion (Misc queries) | |||
Linear Mode
