Question about Microsoft Excel for PC

# Multiple letters in each cell, want to add the letters and tally how many of each

I am working on a spreadsheet and need to enter several different letters as answers to questions (ie a,c,e)  I'd like a way to tally each individual letter at the end of the spreadsheet to find the total number of a's, c's,e's, etc.

Posted by on

• Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

• Master

Use the =COUNTIF function

For example if column a has the letters in it:

=COUNTIF(a1:a100,"a")
or
@COUNTIF(a1..a100,"a")

This will count all of the letter 'a' s in
column a from row 1 to row 100.

Mike

Posted on Oct 31, 2007

## 1 Suggested Answer

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

### Subtracting in Google Spreadsheets - ThoughtCo

To subtract 10 from 20 and have the answer appear in cell C3: Click on cell C3 with the mouse pointer to make it the active cell; Type the equal sign ( = ) in cell C3; Click on cell A3 with the mouse pointer to add that cell reference to the formula after the equal sign;

### Google Spreadsheet Formulas : How to Add, Subtract, Divide, and ...

? 5:36
https://www.youtube.com/watch?v=byTDwUQAwnE May 28, 2014 - Uploaded by Helpfolder
there this is another tutorial on Google spreadsheet and in this tutorial you. we are going to see how you can ...

### How to Subtract Cells in Google Spreadsheet - YouTube

? 1:07
This Tutorial Shows the formula how to Subtract Cells in a Spreadsheet from Google Docs from the Drive ...
formula to add and subtract in google sheets Google Search

Mar 13, 2018 | Google Computers & Internet

### How do I pull a figure from a spread sheet and add it to another in the same file.....

Are you talking about different worksheets in the same file.
go to the other worksheet then go to the particular cell and press = on keyboard
then use mouse to select the other worksheet from the bottom of the spreadsheet .
Then click on the cell you wish to link and press enter key on keyboard.

https://support.office.com/en-us/article/Insert-or-delete-a-worksheet-19d3d21e-a3b3-4e13-a422-d1f43f1faaf2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2

You can also do this to spreadsheets with different file names by opening both spread sheets in different windows and switching between the windows.

you can also copy just the data by copy whole sheet (click on the square in top left hand and copy and then right click paste special on new worksheet - with values only rather than the original formulas from the spreadsheet

Jan 06, 2017 | The Computers & Internet

### I have a column containing a value of a single letter. I need the spreadsheet to sort add rows by letter.

Move the column to A. Mark entire sheet and sort ascending. There are more raffined ways to do this, but this is an easy quick fix...

Sep 07, 2014 | Microsoft Excel for PC

### How to upload products

How to upload products -
While listing products on Amazon is a great way to sell your products and expose them to millions of customers, adding multiple items to your merchant account can be a time-consuming process. Instead of adding products one-by-one, sellers with Pro Merchant Subscription accounts can use Amazon's tools to upload product details in bulk.
1. Download Amazon's pre-built inventory file template from Amazon.com that fits your product category. This template is a Microsoft Excel file. You can use free programs such as Apache OpenOffice Calc and LibreOffice Calc to open and edit the file if you do not own Excel.
2. Open the template in a spreadsheet program. Each template has detailed instructions specific to your product category at the top of the document. Carefully read the instructions before entering your product details so you do not make any mistakes.
3. Print the "Data Definitions" tab in the spreadsheet. This worksheet includes important details on the acceptable values and formats you can enter into the template. Keep it handy as a reference when filling out the template.
4. Add your inventory items to the template. Pay close attention to template columns to make sure you enter product details in the correct cell. Enter details such as SKU, product ID, title, brand, manufacturer, description and more. You can also add bullet points to expand on the description of your item in the cells labeled "BulletPoint1," "BulletPoint2," "BulletPoint3" and so on.
5. Save the file in the .xls format when you are finished entering product details. In Excel, OpenOffice Calc and LibreOffice Calc, select "File" from the program menu, then click "Save As."
6. Save the file again as a tab-delimited .txt file, per Amazon's instructions. This is the file format needed for uploading on Amazon.com. If a dialog pops up that says the file format does not support files containing multiple worksheets or something similar, click "OK." If another warning says the document contains features incompatible with the file format, click "Yes."
7. Log in to your Amazon seller account. Click "Upload multiple items," then select the template type for the file you want to upload. To completely replace all of the items in your inventory, select "Purge and Replace."
8. Click "Select File Upload," then "Browse." Locate your product file on your computer using the dialog box, select it, then click "Upload Now." After you upload the document, the page shows the status of the upload. Refresh the page to see the upload progress. Files over 5MB may take several hours to process.

Aug 05, 2014 | Work Safety

### How to export tally 9 to excel sheet

Hi,
Great question and there are two way export date. Please follow step by step instruction.
1. In the Balance sheet screen click E : Export or press Alt+E.
2. Select the required language from the list of Languages displayed.
3. Select a format from the list of Formats displayed.
4. By default, the exported file will be stored in C:\Program Files\Tally.ERP 9 for Windows 7 and C:\Tally.ERP 9 for Windows XP operating systems
5. Press Enter to accept the default Output Filename or type the filename of your choice in order to save the file with a different name.
6. Press Enter to accept the default Output Sheet Name.
7. To update the existing file select Yes in Update Existing File.
8. To format the contents of the file select Yes in Excel (Spreadsheet) formatting.
9. Select Yes for the Field with Colour, to retain the background colour in the exported file.
And Second:
selecting the ASCII (Comma Delimited) format, the user can export all the reports or data from Tally.ERP 9. The data exported is converted to plain text separated with commas and stored in a file with the extension .txt. This file format is widely used for emailing and used for importing data into another company using Tally.ERP 9

http://www.tallysolutions.com/website/CHM/TallyERP9/Data_Management/Export_Formats.htm

Thanks,

Jun 10, 2014 | HP Office Equipment & Supplies

### EXPORT TALLY7.2 DATA INTO EXCEL SPREADSHEET

Hi,

Go to Gateway of Tally> Balance Sheet (Here you can choose any report which you want export in tally)

Step 1: In the Balance sheet screen click E: Export or press Alt+E.

Step 2: Select the required language from the list of languages displayed.

Step 3: Select a format from the list of formats displayed.

Step 4: By default, the exported file will be stored in C:\Program files\Tally.ERP 9 for windows 7 and C:\Tally.ERP 9 for windows XP operating systems.

Step 5: Press Enter to accept the default output sheet name.

Step 6: To update the existing file select yes in update existing file.

Step 7: To format the contents of the file selects yes in Excel (Spreadsheet) formatting.

Step 8: Select yes for the filed with color, to retain the background color in the exported file.

Step 9: Accept to export the Balance Sheet to an excel file.

Thanking you

davevipul197

Jun 04, 2011 | Tally T2245 Matrix Printer

### If/Then Formula

not really
Just create the
formula =if(e1=1,"X",if(e1=2,"Z","")) in cell K1 then
formula =if(f1=1,"X",if(f1=2,"Z"),"") in cell L1 then
formula =if(g1=1,"X",if(g1=2,"Z","")) in cell m1 then
formula =if(H1=1,"X",if(h1=2,"Z","")) in cell N1 then
if you wanted another statement
formula =if(H1=1,"X",if(h1=2,"Z",if(h1=3,"Y,""))) in cell N1
this is nesting the if statement you just keep adding conditions.
What you are asking I have to type this in 600 times
No just do one line and then highlight the cells with the if in it and then select copy from edit menu or right click and select copy
Then click on next 599 cells by clicking on first cell and hold mouse button down and drag down mouse to last 1000 row of cell and right click mouse and select paste. The formulas will alter accordingly as pasted to each cell

You could also use a vlookup statement
you open another workbook look at bottom of worksheet for tabs to add a workbook.
Then you create a table in other workbook
1 cell A1 H in B1
2 cell A2 Z in B2
https://www.timeatlas.com/vlookup-tutorial/
you would still need to copy the cells down

Mar 30, 2017 | Microsoft Office 2003 Basic Edition...

1. enter = symbol
2. enter ( symbol
2. enter cell location where your cost value is
3. enter * symbol
4. enter 0.7
5. enter ) symbol
6. enter 0.175

eg. =(A3*0.7)*0.175 where A3 is the cell location where your cost amount is

Oct 08, 2008 | Microsoft Windows XP Home Edition

### How to Export trial Balance from Tally 9.2 version to Excel sheet

you select the trial balace--and press Alt+E or click export---then the export details screen came,

Language: Default(all language)
Output file name: trial bal.xls (any name you select)

Excel (spreadsheet) formating: yes
other details you select and accept the screen. then minimise or close the Tally, you open the tally file name at my computer. at the time you can see the file trialbal.

Mar 20, 2008 | Computers & Internet

### Hi friends

Have all worksheets open including the one that is to be the tally sheet.
On the tally sheet, select a cell that you want to link to one of the other sheets and press the equals signto begin the cell formula. Without pressing the enter key, click on the cell in the other worksheet that you want to show up in your tally sheet.
Press enter to complete. This will link that cell in the two worksheets together as long as the spreadsheets remain stored in the same places.

Dec 24, 2007 | Microsoft Excel for PC

#### Related Topics:

371 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert