| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting or adding numbers of the same value
I want to count the number of 1's, 2, in a column. For example i use the
number 1 to represent a smith city resedient, and number 2 to represent jackons city residents, i want to total the amount of each group? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting or adding numbers of the same value
hi
=countif(A1:A500,1) and =countif(A1:A500,2) Trick...if your two formula were in say B1 and B2, in C1, you could put the number 1 or 2 then have only 1 formula like this.... = countif(A1:A500, C1) the formula would count whatever is in C1. Regards FSt1 "luckysg" wrote: I want to count the number of 1's, 2, in a column. For example i use the number 1 to represent a smith city resedient, and number 2 to represent jackons city residents, i want to total the amount of each group? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting high numbers from low numbers between two rows | New Users to Excel | |||
| Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
| Sorting numbers with differing numbers of digits | Excel Discussion (Misc queries) | |||
| Sorting and Adding Space | Excel Worksheet Functions | |||
| Sorting and adding | Excel Discussion (Misc queries) | |||
Hybrid Mode
