Question about Business & Productivity Software

1 Answer

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

1 Answer

  • 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
  • 242 Answers

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

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

1 Answer

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

1 Answer

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:...

2 Answers

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

1 Answer

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

1 Answer

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

2 Answers

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

1 Answer

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)

1 Answer

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 Business & Productivity Software

1 Answer

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

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

68 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...