Question about Microsoft Computers & Internet

# Related MS Excess 2003

In report, how could "Sum" of a column obtained

Posted by on

• Cheryl May 11, 2010

It is unclear whether you are referring to Microsoft Excel or Microsoft Access. Please clarify!

~~Cheryl

×

• Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

• Master

Hi Esd,

I'm assuming you meant 'Excel' since 'SUM' is the command you're looking for.

If your totaling Column D for rows 5 through 35, this is what you would need in the cell your total would be:

=SUM(D5:D35)

Also, when in doubt, Click on the '=' (equal sign) in the formula bar for a list of functions and help using them.

Any problems? Click the Askme button near my name.

Thanks for using Fixya.
Mike

Posted on Dec 07, 2008

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

### I have three columns that equal a sum column. I now want to take the sum column and find out what 3.33 percent will be. This is a commission.

=SUM(A1,B1,C1)*3.33% or =SUM(A1,B1,C1)*.0333
(A1, B1, C1 are the cells that contain the sum of the individual columns.
=SUMCOLUMN * 3.33% (enter the cell of the sum for the three columns) = C24*3.33%

3.33% =0.033
=CELL * 0.0333
=CELL * 3.33%

May 12, 2016 | Microsoft Excel for PC

### Ms Access 2003

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

### MS Project report customization

1.Click View > Resource Sheet.

Click View > Tables, Cost to apply the Cost table.

Review the cost columns.

Apr 10, 2017 | Microsoft Office Project Professional 2003...

### Ms-office

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:
1. =A1-A2
2. =SUM(A1,-A2)
The above formulas refer to cell reference A2 subtracted from A1. As usual, you can use number values instead of cell references.

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

Jul 08, 2009 | Microsoft Office Excel 2003 for PC

### FORMULA PROBLEM IN MS EXCEL

The cells you are trying to sum are probably text and not numeric values. Format them as number or convert them to numbers.

Apr 18, 2009 | Microsoft Office Excel 2003 for PC

### I just wanted to know how to add a new cloumn in ms word

I just need to know how to be able to click into a cell for a formula sum and have it to stay in that cell.

Aug 20, 2008 | Microsoft Office 2003 Basic Edition...

### Office 2007 prduct key codes

if you download a newer trial from microsoft.com (from after march 2007) there's a link "buy an online product key"
if that doesn't work just by office on CD

and if you don't want to pay, then don't ask here, or i'll have to report you

Dec 21, 2007 | Computers & Internet

### Printing a report

IS IT THROUGH EXCEL THAT YOU WANT TO TAKE THE PRINTOUT FROM? YES - OPEN A FRESH EXCEL SHEET. COPY AND PASTE EVERYTHING INTO THE NEW SHEET. TRY TAKING A PRINTOUT. YES - GOOD. NO - UNINSTALL AND REINSTALL MS OFFICE TRY ANOTHER PRINTOUT. YES - GOOD NO - CONTACT MICROSOFT VENDOR. NOTE : NO PRINTER DISQUALIFIES ANY MS DOCUMENT.THUS ERROR FROM MS VENDOR.

Sep 17, 2007 | HP Deskjet F340 All-In-One Printer

### Access 2003

Hi smiths, Try adding a Label to the report in Design View. In the Properties, select the control source for this field. Insert one for your vertical and horizontal calculations as needed. Hope this helps. Regards DeltaC

Sep 10, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

96 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert