| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
number of cell
hi all
if i have the following: a 12 b 10 c 15 a 11 a 7 a 14 c 1 c 21 how i can collect the following no of cell which hvae a and total of it for example the result will be as following the number of a cell will be 4 and in other cell get the amount of a only 12+11+7+14 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
number of cell
no of cells: =COUNTIF(A:A,"a")
sum: =SUMIF(A:A,"a",B:B) Regards, Stefi M.K ezt *rta: hi all if i have the following: a 12 b 10 c 15 a 11 a 7 a 14 c 1 c 21 how i can collect the following no of cell which hvae a and total of it for example the result will be as following the number of a cell will be 4 and in other cell get the amount of a only 12+11+7+14 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying the number of a custom formatted number cell | Excel Discussion (Misc queries) | |||
| Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
| formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Creating a certain number of entries based on a number in a cell | Excel Worksheet Functions | |||
![M.K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
