I have data in column A,B,C,D,E,F, i need total of A+C+E in G column and total of B+D+F in H column.

I know one formula i.e. on column G we input =A+C+E, then the total will come but I need an alternative formula for this, could you help me out in this issue, Advance Thanks, Harish

1. Make sure you have entered the numbers you'll need in necessary columns

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

Aug 03, 2010 | Microsoft Excel for PC

Yes,

That is Select the Cells which you want to SUM and Press**Alt+=**

This will bring the total just below the selected cells.

Thanks

Iqbal

- Select the column. (click on top of the column it will select)
- Right Click and select Format Cells.
- Select
**Currency**in**Category**then press**OK**

That is Select the Cells which you want to SUM and Press

This will bring the total just below the selected cells.

Thanks

Iqbal

Apr 02, 2008 | Business & Productivity Software

If Access is anything like Excel, you can put in one of the cells:
=SUM(A1:A5)
If I remember rightly. That will add all the values from A1 to A5 together and display it. Alternatively, you can do =SUM( and then select all the values you wish to add together with your mouse by dragging, or selecting individually by holding CTRL whilst individually selecting.
Hope this helps, because I'm only going under the assumption that Access is similar to Excel. Either way, you will need to use a formula similar to the one I just showed you.

Sep 10, 2007 | Microsoft Office Standard for PC

Here is how you could do the formula with two one column having the hours of each day in it and the overtime being in another cell:

Example:

Column A Column B

8

8

8

2

8

8

0

Total 40 OverTime 2

Formula in this cell where 40 is at:

=IF(SUM(A1:A7)>40,40,SUM(A1:A7))

Formula in cell where 2 is at:

=IF(A8>40,0,SUM(A1:A7)-A8)

Let me know if this helps.

Example:

Column A Column B

8

8

8

2

8

8

0

Total 40 OverTime 2

Formula in this cell where 40 is at:

=IF(SUM(A1:A7)>40,40,SUM(A1:A7))

Formula in cell where 2 is at:

=IF(A8>40,0,SUM(A1:A7)-A8)

Let me know if this helps.

Jan 01, 2010 | Microsoft Excel 2007 Home and Student...

For example, you have three numbers from A1 to A3. On row A4, type =SUM(A1:A3).

That should do it. :)

That should do it. :)

Sep 16, 2009 | Microsoft Office Excel 2007

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

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

**columns: A B C D**

**rows**

**1 ** 20 3

**2 ** 10 4

**3 ** 15 2

**4 ** 1 2 3

Then suppose you type in the following formulas (in the D column):

**columns: A B C D**

**rows**

**1 ** 20 3 =A1+B1

**2 ** 10 4 =A2-B2

**3 ** 15 2 =A3*B2

**4 ** 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

**columns: A B C D**

**rows**

**1 ** 20 3 23

**2 ** 10 4 6

**3** 15 2 30

**4** 1 2 3 6

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

Then suppose you type in the following formulas (in the D column):

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Business & Productivity Software

at first select the 1st page data and select data-subtotal from the upper menu list.

then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

columns total in additin cells of rows equal are total

Oct 24, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

If you are using MS Excel then use Text to Columns from the Data menu. Simply select the column then from the Data menu click Text to Columns & follow the simple instructions in the Dialog/Wizard.

Oct 11, 2007 | Microsoft Office Standard for PC

Jan 28, 2016 | Microsoft Excel for PC

102 people viewed this question

Usually answered in minutes!

×