| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding up non numerical values
In one column I will have a variety of letters. (A, B, C etc) In another
cell I want to have the sum of all the A's in that column. In a different cell I want to have the number of B's in the column - and so on. How do I do this? Thanks in advance! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding up non numerical values
Try this:
=COUNTIF(A1:A100,"A") =COUNTIF(A1:A100,"B") etc., where I have assumed your data is in A1:A100. Hope this helps. Pete On Sep 21, 9:10 am, Wooster wrote: In one column I will have a variety of letters. (A, B, C etc) In another cell I want to have the sum of all the A's in that column. In a different cell I want to have the number of B's in the column - and so on. How do I do this? Thanks in advance! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding up non numerical values
Works perfectly. Thanks
"Pete_UK" wrote: Try this: =COUNTIF(A1:A100,"A") =COUNTIF(A1:A100,"B") etc., where I have assumed your data is in A1:A100. Hope this helps. Pete On Sep 21, 9:10 am, Wooster wrote: In one column I will have a variety of letters. (A, B, C etc) In another cell I want to have the sum of all the A's in that column. In a different cell I want to have the number of B's in the column - and so on. How do I do this? Thanks in advance! |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding up non numerical values
You're welcome - thanks for taking the trouble to feed back.
Pete On Sep 22, 7:40 pm, Wooster wrote: Works perfectly. Thanks "Pete_UK" wrote: Try this: =COUNTIF(A1:A100,"A") =COUNTIF(A1:A100,"B") etc., where I have assumed your data is in A1:A100. Hope this helps. Pete On Sep 21, 9:10 am, Wooster wrote: In one column I will have a variety of letters. (A, B, C etc) In another cell I want to have the sum of all the A's in that column. In a different cell I want to have the number of B's in the column - and so on. How do I do this? Thanks in advance!- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Giving letters a numerical value, then adding the total. | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| Adding numbers to an incomplete numerical list | Excel Discussion (Misc queries) | |||
| Numerical values only | Excel Discussion (Misc queries) | |||
| Associated Numerical Values | Excel Discussion (Misc queries) | |||
Linear Mode
