Question about Microsoft Office Standard for PC
I am doing a simple excel chart to show a fundraiser profit. I have 6 grade levels, all of who have products and units sold associated with them. I am not quite sure what cell or where to put the fundraiser overall profit in order to have it be indepenent of a particular grade level. I want that number in my chart. Should it go in a cell completely outside the other data cell fields? recommendations?
You need to create subtotals so that it looks like something like this:
Prod/units Amt. Level Total
xxxx 10.00 1
yyyy 20.00 1
dddd 40.00 2
ffff 30.00 2
To do this I would suggest using the Pivot Table feature of Excel. It is not too hard to use but you do have to know what you want and also have to be sure you are getting results as expected. Like any tool, it has to be used right. You can also use sub-total functions supplied in VBA as well in your cells.
If you want to avoid using VBA functions in cell and deal with ranges, etc., use the Pivot Table Wizard.
Also Google "Excel pivot table wizard" to get more.
Posted on Feb 24, 2008
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.
Posted on Jan 02, 2017
Tips for a great answer:
Apr 24, 2015 | Microsoft Office Excel 2007
Mar 04, 2015 | Computers & Internet
Feb 25, 2015 | Speed Charity
May 31, 2012 | Cell Phones
Mar 12, 2010 | Dell Computers & Internet
Feb 17, 2009 | Microsoft EXCEL 2004 for Mac
Jan 26, 2009 | Microsoft Excel for PC
Jan 05, 2009 | Microsoft Computers & Internet
Nov 16, 2007 | Computers & Internet
Sep 23, 2007 | Microsoft Office Standard for PC
171 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: