Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    mac


Advertisements:






Numbers 09 :: How Do I Create A Sum Of Each Category


There's several columns but I want the data from category and amount.

I have 300 lines of category and amount and when I try to create a chart from that I get a legend of 300 items.

How do I group it by the category so I can see the total of each category?

Information:
MBP Unibody
Mac OS X (10.6.3)


View 3 Replies (Posted: Jun 11, 2010)

Sponsored Links:

Related Forum Messages for Mac:
Numbers 09 :: Sum Of 2 Cells Not More Than 5?
Trying to do a questionary where the sum of 2 cells aren't bigger then 5. How do I do that?

Information:
MacBook (Black)
Mac OS X (10.5.8)

Posted: Aug 20, 2009

View 8 Replies!   View Related
Numbers 09 :: Using Sum Cell Above?
I have a cell A1 that contains a number. I need to make cell A2+A1 then A3+A1 then A4+A1 see where I am going.

So basically I need to do something like =sum((cell above)+A1)

Any one got any ideas. Most evey thing I can find relates to excel and using VB.

Information:
MacBook Pro 15"
Mac OS X (10.6)

Posted: Oct 10, 2009

View 2 Replies!   View Related
Numbers 09 :: Calculating Sum Every Fifth Element?
Is there a simple way to sum every fifth element in a list? i.e 1+6+11, then 2+6+12 etc?

Information:
Intel iMAc 24"
Mac OS X (10.5.7)

Posted: Jan 19, 2010

View 4 Replies!   View Related
Numbers 09 :: Dynamically Sum Each Value In Table
If I have a table like:
____A_____B__
1 | JAN | $10
2 | JAN | $15
3 | FEB | $11
4 | MAR | $25
5 | MAR | $20
6 | MAR | $10

How can I produce a SUM for each value in Column A (i.e. the month)?

What I'm after is analogous to a SUM and GROUP BY in SQL and the result would look like:
JAN | $25
FEB | $11
MAR | $55

Information:
MacBookPro 13"
Mac OS X (10.6.1)

Posted: Jun 22, 2010

View 8 Replies!   View Related
Numbers 09 :: Sum Of Same Cell From Different Sheets?
I'm trying to keep an inventory based on order forms to track how many of something I've sold.

I want "Sheet 1" to total the numbers in the same cell on other sheets in the same file.

I'm wondering if there is something like

=(Sheet 2 :: Table 1 :: B2):(Sheet 100 :: Table 1 :: B2)

that would work from the 2nd sheet down through the 100th sheet.

Information:
G5

Posted: Jul 1, 2010

View 6 Replies!   View Related
Numbers 09 :: How To Do A SUM Of All Cells Of A Certain Color
I have a spreadsheet that I'm categorizing certain budget items by cell color. these are not in a row. I think there is a way with IF statements to select all the cells of a certain color that contain numbers and do a sum of them. This will allow for easy graphs of those categories.

Information:
Macbook Pro 13"
Mac OS X (10.6.4)

Posted: Sep 13, 2010

View 4 Replies!   View Related
Numbers 09 :: How Do I Sum All Durations Spent On Mondays
Assume I have the following table:

How do I sum all durations spent on Mondays? (6h54m)

Information:
MBP 2.4
Mac OS X (10.5.8)

Posted: Aug 16, 2009

View 5 Replies!   View Related
Numbers 09 :: Can A SUM/AVERAGE Ignore Cells With No Value
I have a table (say Table1) that uses SUM and AVERAGE, referencing values from another table (say Table2). Table2 pulls values from another sheet that serves as an information database. I like to keep four slots available in Table2 at all times, but I don't always use all four slots. When I do NOT use all four slots, however, the SUM and AVERAGE functions in Table1 won't work, since it's seeing an incomplete formula.

I'm just wondering if there is a way for it to only SUM and/or AVERAGE cells that have a value within the specified range, or if I'll need to keep adding/removing slots in Table2 depending on how many slots I'm working with at the time.

Information:
iMac
Mac OS X (10.5.4)

Posted: Mar 9, 2010

View 3 Replies!   View Related
Numbers 09 :: Chart On Sum Totals Does Not Show Anything
I am creating a spreadsheet that shows the total amount of water we use at our company on a daily basis. I created a sum total for the weekly totals of the different areas we have and when I try to create any type of chart, it will show the different areas on the legend however it will not show any of the data in the actual chart. I have no idea how to transfer sum total info to a chart.

Information:
Intel iMac Aluminum 24 inch
Mac OS X (10.6.2)

Posted: Aug 9, 2010

View 9 Replies!   View Related
Numbers 09 :: Chart / Columns Labels (Sum Of Series)
I am building a Column chart I'm not sure what its called but its where you add different series together to make a column chart (this option is second from the top and on the left side in the charts selector). I would call it a additive column chart. What I want to do is add a label to the chart. However, I don't want the labels of the individual series but the sum of the series. I would like this number to appear at the top of the Chart Column.

So for example if my data for a particular column says:
Canada 10
US 5
Other 3

I want the number 18 to be displayed in the chart. It is an additive column of course so why can't I show the total? I just want to show the total somehow as a number on the chart.

Information:
MacBook Pro
Mac OS X (10.5.8)

Posted: Aug 9, 2009

View 1 Replies!   View Related
Numbers 09 :: Sum Several Cells From Certain Categories In A Mixed Table?
I've been wrecking my brain for the right formula, consulted my smart handbooks, searched this and other forums - but I just can't get the formula right for this task.

I've got two tables. (And a standard form.)Table 1 I'd like to use like a notesheet, where I can list certain tasks and materials which are related to each other

Information:
iMac 8.1
Mac OS X (10.5.8)
PowerBook G4, Mac OS X (10.3.9)

Posted: Dec 14, 2009

View 6 Replies!   View Related
Numbers 09 :: Won't Add Sum Of Certain Number Of Symbols
Is it possible in Numbers to have it add the number of symbols occurring in a given row? For example, the number of letter A's that might occur in the row? And is it also possible to have Numbers add up the number of different symbols in the same row, say how many B's and how many C's?

In other words, say I wrote "horses" in two cells in a row, "pigs" in three more cells in the same row, and "dogs" in five cells, also in the same row, could Numbers tell me at the end of the row that there were two horse, three pigs, and five dogs? I have looked in Numbers Help, and in the Numbers User Guide, and haven't found an answer, at least not one I understand. I don't want to get that guy from France mad at me.

Information:
iMac
Mac OS X (10.5.7)
iWork 09

Posted: Jun 4, 2009

View 2 Replies!   View Related
Numbers 09 :: Formula To Provide Sum Of All Cells In Specific Range
Let's say I have two columns: A and B. In Column A are letters to specify categories (e.g., IND, WB, ...). In Column B are number amounts. What I would like to do is to write a formula that will provide the sum of all cells in the range B2:b10 as an example that are also part of category "IND"--for the program to be able to pick out the three IND related cells in column B and tell me the sum of their contents. (I could change the category specifiers to numerical specifiers if that would help.)

Information:
MacBook
Mac OS X (10.6.1)

Posted: Feb 7, 2010

View 2 Replies!   View Related
Numbers 09 :: How To Extract Category Subtotals
The Categories feature is cool. I have a table that has been categorized by one column with subtotals for each. I'd like to create a small second table that displays only the subtotals from the first as a kind of summary. Is that possible?

Information:
Intel iMac, iBook G4
Mac OS X (10.5.6)
HP Laserwriter, PowerWave, Edirol PCR-30, LaCie d2

Posted: Feb 25, 2009

View 1 Replies!   View Related
Numbers 09 :: Formatting A Category Subtotal?
Is there any way to adjust the formatting of a category subtotal row?

I have a column of time durations (formatted h:m) that is subtotaled by a category. The problem is the automatic formatting is not in h:m format, and in the inspector the format option is grayed out.

Posted: Mar 11, 2009

View 2 Replies!   View Related
Numbers 09 :: Using Cells As Category Values
I have a table that has a column of categories, and then a column of values. I'd like to build a chart that used the first column as the values for the categories of the chart. Is there a way to do this?It'd build a bar chart using 10, 5 and 9 as values, and to the left, the values would be listed as MATH, READING and SCIENCE.

The charts that I'm being asked to do have a common format, but different categories. So the next graph I have to build from this template may have SPEECH, MATH, and GYM, for example. Right now, I need to alter those categores by changing each line of the chart by hand.

Information:
G5, Titanium Power Book
Mac OS X (10.3.x)

Posted: Apr 23, 2009

View 22 Replies!   View Related
Numbers 09 :: Summarize By Category Into Master File?
I know how to create multiple Sheets within a single Numbers file, and how to summarize cells from various sheets within that file to a Summary Sheet. I'm trying to build an Expense Report Template that will be used by multiple individuals, and rather than having them all work in a single file, I would like to have a standard naming convention that allows for a single, summary file. The Template would have pop-up menus for categories.

Example:

File 1
Meals - $50.00
Rental Car - $200.00

File 2
Meals - $25.00
Hotel - $150.00

File 3
Meals - $25.00
Rental Car - $150.00
Hotel - $200.00

Summary File
Meals - $100.00
Rental Car - $350.00
Hotel - $350.00

When someone adds File 4 with additional expense items for Meals, Hotel, etc, the Total for that category in the Summary file would be updated, giving me a running total for that expense category. Does that make sense? Is it possible?

Information:
Macbook
Mac OS X (10.4.11)

Posted: Apr 5, 2009

View 4 Replies!   View Related
Numbers 09 :: Making Two Category Bar Charts?
I'd like to make a bar chart with 2 category axes, with the y-axis being the categories. It would (of course) have to be a 3-d chart. It would look a little like the Numbers logo!

Genetics people out there will know the MxN Punnet squares with probabilities? I want to make the probabilities the y-axis values, and the M and N categories the two x-axes.

Information:
MacBook 13"
Mac OS X (10.6)
2GB

Posted: Sep 11, 2009

View 15 Replies!   View Related
Numbers 09 :: Trying To Make A Logarithmic Category Axis
I'm trying to keep my y-axis linear and my x-axis logarithmic on a simple line chart – is this impossible, for some reason? I see no mention if it in the documentation, and I've spent hours trying to figure it out.It seems odd that it'd be so easy to make change the scale of the y-axis, but not the x-axis. Am I just completely blind?

Information:
iMac 26" and Late 2009 MBP
Mac OS X (10.6.2)

Posted: Mar 9, 2010

View 3 Replies!   View Related
Numbers 09 :: Monthly Averaging Category Sums?
I have a monthly budget sheet with several category heading rows, and multiple entries under each of these category headings. In each month/column, entries are automatically summed for each category heading in the appropriate category heading row. How can I get this table, or another on the same sheet, to give me averages across each category heading row, i.e. monthly averages for each category?

Information:
Mac OS X (10.6.3)

Posted: Apr 25, 2010

View 3 Replies!   View Related
Applications :: IWork Numbers - Formula With Category
I have a list of expenses and there are columns such as "Description, Cost" the usual, but I also made one named "Type" that is populated with either "Business, Personal," or "Fixed Expenditures".

I would like, then, to make another table that links to the first with three rows. Each one adds the total cost of Business, Personal, and Fixed Expenditures. How can I accomplish this?

I want to divide the expenses into expenses types and create a sum for each type.

Basically, it categorizes the expenses and puts them in three different totals: one for each "Type" of expense.

Posted: Aug 14, 2010

View 3 Replies!   View Related
Numbers 09 :: Category Totals Go From Monthly To Yearly Sheet
How do I get Numbers to automatically copy a number from one sheet to another? I am doing a financial plan and want various category totals to go from each monthly sheet to a yearly sheet. So, for example, the total of housing costs for January would automatically also show up in a Yearly sheet under the month of January.

Information:
Powerbook Pro
Mac OS X (10.5.8)

Posted: Oct 11, 2009

View 1 Replies!   View Related
Numbers 09 :: Email ID In Address Book - Field Category
If I enter an E-mail address in my Address Book and then click on the field tag on the left of my entry I often get the "field category" window appearing - i.e. "father, mother .... Email address" (with a tick showing against Email address). At other times (on other Address Book Cards) I got "Send Email" which is what is needed to create an Email using the Card's Email entry.

Information:
MacBook Pro 13 inch
Mac OS X (10.6.2)
iWork 09

Posted: Jan 30, 2010

View 2 Replies!   View Related
Numbers 09 :: Chart Category Labels - Using Diagonal Instead Of Horizontal
I made a bar chart and the labels are longer. I would like to have them be diagonal instead of horizontal, which is the auto setting. Numbers seems to make every other one disappear, because otherwise they would write over each other. If they are at an angle, then you could see the whole label.

Information:
Mac OS X (10.6.4)

Posted: Nov 21, 2010

View 5 Replies!   View Related
Numbers 09 :: Make Chart Using Subtotal Cell Of Category Row
I'm having some trouble when I try to make a chart using the subtotal cell of the category row. Is there a way to do this?

Posted: Feb 25, 2010

View 4 Replies!   View Related
Numbers 09 :: Showing Category (data Set) Titles On The Axis Of A Graph?
I'm trying to use text in the x-axis of my scatterplot instead of numbers. The help section told me to "Choose Show Categories from the Choose Axis Options pop-up menu under Category Axis in the Axis pane of the Chart inspector."

The thing is, when I click on the Choose Axis Options pop-up, there isn't a Show Categories selection.

Information:
macbook
Mac OS X (10.5.6)

Posted: Jan 10, 2010

View 4 Replies!   View Related
Numbers 09 :: Multiple Text Lines Within Chart Title Or Axis Category?
I'm designing charts with lengthy titles and axis categories. The default title or axis setting in the chart inspector, when I select 'show title' or 'show categories', is 1 line of text. I'd like to format the title text box as if the text is wrapped within a taller and narrower text box.

I thought I knew of a way to divide a chart title (or axis category) into multiple lines of text. I can't seem to remember how I accomplished this. I realize I could make custom text boxes, but I'd like to avoid doing this for each category and title across multiple charts.

How can I format a chart title with 2 or 3 lines of text instead of the default 1?

Information:
iMac
Mac OS X (10.6.4)
3.06 GHz Intel Core 2 Duo

Posted: Dec 12, 2010

View 6 Replies!   View Related
Software :: Can Manually Record Debit And Credit Transactions By Description, Category And Sub-category
I currently use Quicken for Mac 2007 for my budget and finance.fonts are far too small for me to see clearly and cannot be changed. My budget and finance requirements are reasonably straightforward1. Create income and expenditure categories and sub-categories 2. Create 3 accounts (cheque, savings, credit) in which I can manually record debit and credit transactions by description, category and sub-category 3. Create annual budgets with specified amounts each month (not average amounts) for categories and sub-categories

Posted: Aug 10, 2009

View 10 Replies!   View Related
Numbers 09 :: Showing SUM Of Minutes As Hours & Minutes?
I'm using numbers as a timelog (as I see others doing the same). I can't, however, find the solution to my problem in the previous post search. I would appreciate any help anyone can offer, so thank you in advance.I have created a separate spreadsheet in the same document to tally up the total hours for the week. Adding up Monday, Tuesday, Wed, etc. Elaborate example below.I am pulling in the SUM cell from each sheet/table individually I would like to SUM the column of these times pulled in from each individual sheet but I keep getting an error when I just use a basic SUM formula.

Posted: Oct 30, 2010

View 9 Replies!   View Related
Applications :: Numbers - Sum Column Based On Value In Other Column
I'm sure this is easy to answer by someone with basic spreadsheet skills, which I lack... I have a column of numbers (miles) and a column of use (Personal, Medical, Business). How do I set up 3 formulas so that I get the sum of the mileage column for each of the Personal, Medical, and Business categories?

Posted: Mar 12, 2010

View 2 Replies!   View Related
Numbers 09 :: Checkbook Register - Drop Down Menu From "Category" Column
I may be overlooking the answer somewhere, I have searched all resources, but I am still unable to locate it. I like the way the register is set-up, however, for the life of me I cannot determine how to change or add items to the "drop-down" menu in the "category" column. How does one create the drop-down menu, and or how are the names changed or added in the existing one?

Information:
imac
Mac OS X (10.4.6)

Posted: Oct 23, 2010

View 6 Replies!   View Related
Numbers 09 :: Formula To Create List Of 2000 Numbers
I am in deep deep trouble and I am in need of formula to create a list of about 2000 numbers.

I have a table 4 coluumns and 7000 entries:
Column A = School Code
Column B = Grade Level
Column C = Number of Students
Column D = Avg Score per grade Level

I need to create a formula that will give me 1 score per school regardless of grade level. I can create this formula (select all the column As that equal each other, add up students, add up scores, divide) but I cannot figure out make it repeat itself 2000x without manually entering it 2000x.

Information:
MacBook Pro
Mac OS X (10.6)

Posted: Aug 30, 2009

View 6 Replies!   View Related
Numbers 09 :: How To Create If Statement
How do I create this function?

C2 | C3
700 | 1*
720 | 2*

* If the value of C2 is between 690 & 710 return a value of 1 in C3.

Posted: May 21, 2009

View 5 Replies!   View Related
Numbers 09 :: Need To Create Histogram?
I am in stats. I need to create histograms. Lame excel 2008 does not allow me to. I cannot find the option in Numbers. If numbers cannot create histograms, is there any mac software that can?

Information:
MBP 17" 2.4G
Mac OS X (10.5.1)

Posted: Dec 6, 2009

View 7 Replies!   View Related
Numbers 09 :: How To Create An Average Per Km
I train marathoners and need to be able to have in box A "number of km" in box B "time" and an output in box C of the average per km --- I used to have this in excel but can't find the correct formula in numbers.

Information:
MacbookPro 15"
Mac OS X (10.6.1)

Posted: Nov 6, 2009

View 1 Replies!   View Related
Numbers 09 :: How To Create A Function
I'm trying to work on a family budget but I would like to know how to create a function in numbers where I divide the monthly into a weekly

Information:
iMac
Mac OS X (10.6.3)

Posted: Jun 5, 2010

View 3 Replies!   View Related
Numbers 09 :: Create A Template ?
I am looking to create a template. I would like to be able to list an item then a retail price, price sold for and last a running total of sold for.

Posted: Jun 7, 2010

View 1 Replies!   View Related
OS X :: How To Create Histogram In Numbers
I need to create a histogram for school. How do you create one in Numbers '09?

Posted: Sep 21, 2010

View 2 Replies!   View Related
Numbers 09 :: How To Create A Mixed Chart
What I need to do is to create a chart with two different types of data. On the left I want to show "body temperatures" and on the right, I want to show the amount of thyroid medicine consumed that day for that body temperature.

Information:
Mac Pro & MacBook
Mac OS X (10.5.6)

Posted: Apr 23, 2009

View 5 Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved