# Excel I want to add up some numbers but I only want them to be included if I have put a letter like let say c for cash in the column next to the number is this possible or how can I do it?

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 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.

• Expert

Use IF statement:
IF(A2 = "c",action if true, action if false)
wherein A2 is the column which could contain the letter c for cash

Posted on Mar 30, 2008

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).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### IS THERE A FORMULA IN EXCEL THAT WILL HIGHLIGHT CELLS THAT MATCH A NUMERICAL INVENTORY LIST?

One way would be to create a colunn C and use the formula: =COUNTIF(B\$2:B\$200,A2) in cell C2. Then copy the formula down to C200. (assuming you have 200 entries in B...). This will put a "1" next to every number in Column A that has a match in column B. Then you could put a conditional formula in column A that will highlight the cell if the value in column C is equal to 1. Alternatively you could also simply filter for 1's in column C and then manually highlight the cells that show up in A!

Sep 16, 2014 | Microsoft Excel for PC

### 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

### I want to find out what is meaning of cell in microsoft excel 2007 windows.

The rectangular box identified by a unique letter - number combination. You would type your number or text into this box.

A cell is the intersection of one row and one column. (EXAMPLE: A1, which refers to the cell made by the intersection of Column A and row 1.)

Nov 09, 2010 | Microsoft Office Excel 2007 Upgrade:...

### I need a running balance in a column for a petty cash spreadsheet

In the first row of numbers, assume row 3 for example (leaving 2 rows for titles, put in cell E3: =C3+D3. In the next row (assuming row 4, put in cell E4: =C4+D4+E3. Use fill down to populate this formula all the way down.

Jun 18, 2009 | Microsoft Excel for PC

### Want to add up a column and put the total at the bottom

Press Shift + Space Bar to Select an entire column and then press CTRL + "+" key to add a new column.

To get the total press ALT+ "+" + Enter key together.

Mar 15, 2009 | Microsoft Excel for PC

### CAN GET COLUMNS TO ADD UP AND GIVE TOTAL ONLY GET SUBTOTALS

Use the function =sum() to add numbers. To sum, for example, all of column A, enter in the formula bar =sum(\$A:\$A). You can use the subtotal function within the range you are adding and the answer will not count towards the final total.

Mar 14, 2009 | Microsoft Excel for PC

### Excel - format cells

change the regional setting in control pannel for number format.
Please rate this post if found useful

Jan 06, 2009 | Microsoft Excel for PC

### Input data

If you want to transfer your data into SAS, SPSS, or some other program, follow these guidelines:
The cells in Row 1 should contain the column's eventual data set name. Each name should be a relatively short and unique acronym that clearly identifies the data. It should begin with a letter and contain only letters, numbers, or an underscore ( _ ) where spaces would naturally fall. Avoid using special characters such as \$, &, @, in variable names. Since each row represents the values from one subject, the first column(s) should contain one or more variables that give each subject a unique identifier. They become especially important if you need to merge two or more data files.
In Excel, data formats are defined for a range of cells rather than for a complete column. For this reason it is important that each entire column, including cells with missing or uncollected data, have one, and only one, format. Actually, you do not need to format the entire column, only the portion you will eventually use. Highlight that portion and select the appropriate format from the Format/Cells option. Do not select formats that will enter commas, dollar signs, or other visual enhancements. Numeric, text, and date formats (e.g. mm/dd/yy is often a good choice) are probably the only formats you'll ever need.
The "Split" option (under the "Window" pull-down menu) keeps the row of variable names and the columns of identifiers in view, whatever range of cells in the worksheet you may need to review. First place the cursor at the most extreme upper left-hand corner where data entry begins (e.g., the intersection of Row 2 and the column in the upper left-hand corner where data appear) and then select "Split" from this menu. For any row or column of the worksheet you move to, you'll know exactly which variables you are observing (column names) and their associated ID values (rows).
For versions of Excel later than 4.0, one file can contain multiple worksheets. By default, the tabs at the bottom of these sheets are supplied names ("sheet1," "sheet2," etc.). You can change these names by clicking this space with your mouse and entering a new name. Use the same conventions for first-row variable names: use a short acronym of the page contents that begins with a letter, use only letters or numbers, and enter the underscore ( _ ) where a space naturally falls.

Jan 05, 2009 | Sage Instant Accounts 8.0 (013604ug)

### How to add % (Percentage column ) in the excel

The formula is 200/700 equals the percentage;if you're in columns a, b, and c, the formula in c1 will look like:
=b1/a1.

Then you can format the cell to show the number (.2857) as a percentage (28.57%).

Jan 03, 2009 | Microsoft Computers & Internet

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

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

Oct 31, 2007 | Microsoft Excel for PC

## Open Questions:

#### Related Topics:

68 people viewed this question

Level 3 Expert

Level 3 Expert

Level 3 Expert