| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to total words
I have a spreadsheet with two columns like below.
I'd like to get a total of column B. For instance, Apple=4, Mango=2, Pineapple=1/ Is this possible? Orchard Fruit A Apple A Mango B Apple B Mango C Pineapple D Apple E Apple |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to total words
Yes.
In C2: =Countif($B$2:$B$500,B2) And drag down Or, create a summary table below or to the right of your data using advanced filter, copy uniques to another location, then replace B2 with the location of the top item of the summary table and drag down. "Simone" wrote: I have a spreadsheet with two columns like below. I'd like to get a total of column B. For instance, Apple=4, Mango=2, Pineapple=1/ Is this possible? Orchard Fruit A Apple A Mango B Apple B Mango C Pineapple D Apple E Apple |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to total words
Thanks for the answer, it works perfectly.
"~L" wrote: Yes. In C2: =Countif($B$2:$B$500,B2) And drag down Or, create a summary table below or to the right of your data using advanced filter, copy uniques to another location, then replace B2 with the location of the top item of the summary table and drag down. "Simone" wrote: I have a spreadsheet with two columns like below. I'd like to get a total of column B. For instance, Apple=4, Mango=2, Pineapple=1/ Is this possible? Orchard Fruit A Apple A Mango B Apple B Mango C Pineapple D Apple E Apple |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert numeric to words Example 525 in words (Twenty five | Excel Discussion (Misc queries) | |||
| What equation will total number of cells with specific words? | Excel Worksheet Functions | |||
| i need a number total derived from words | Excel Worksheet Functions | |||
| how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Linear Mode
