Question about Microsoft Computers & Internet

1 Answer

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

×

1 Answer

  • 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
  • 1,498 Answers

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

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

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

1 Answer

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

3 Answers

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

2 Answers

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

1 Answer

How to get 1 value from report to another form in ms access


You'll have to use a separate Group By query to get the summed data you are looking for, you cannot pull it off the report.

Feb 06, 2009 | Microsoft Computers & Internet

1 Answer

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

3 Answers

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

1 Answer

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

1 Answer

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

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

95 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18344 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...