| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help adding letters in column
i need help...
i have a sheet that looks like this for example apples p pears v banana p cherry p grapefruit v my questions is - is there a formula that i can use to add up the "p's" in a specific column with out counting them manually??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help adding letters in column
hi,
are the values (fruits and letters) in the same column? if so example 1 - same column in column A... =countif(A1:A100,"*p") if not exaple 2 - different columns -fruits column A, letters column B... =countif(B1:B100,"p") Adjust to your data. Regards FSt1 "melisa0820" wrote: i need help... i have a sheet that looks like this for example apples p pears v banana p cherry p grapefruit v my questions is - is there a formula that i can use to add up the "p's" in a specific column with out counting them manually??? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help adding letters in column
=COUNTIF(A1:A100,"P")
"melisa0820" wrote: i need help... i have a sheet that looks like this for example apples p pears v banana p cherry p grapefruit v my questions is - is there a formula that i can use to add up the "p's" in a specific column with out counting them manually??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
| adding numbers with letters | Excel Discussion (Misc queries) | |||
| Adding "letters (column headings)" | Excel Discussion (Misc queries) | |||
| FORMULAS FOR ADDING LETTERS REPRESENTING NUMBERS | Excel Discussion (Misc queries) | |||
| adding letters in a payroll calendar | Excel Discussion (Misc queries) | |||
Linear Mode
