=SUMIF(TableName :: Category,"=Groceries,TableName :: Price)
Then my function would add up every expense that has the category "Groceries". So, I wanted my function to look through the expenses of my original table. The format is =SUMIF( test-range," Condition, Sum-range).Ģ.) What standards you are looking for ("the condition")ģ.) and if the standards are met, where are the numbers that you want to add located The SUMIF function adds all the numbers you give it if they meet a certain condition that you specify. This is where the SUMIF function comes in. I don't need to know how much I spent on everything else, just groceries. Let's say that I have a category called 'Groceries' and I want to know how much I spent on groceries. In column A I listed out all of the expense categories. Column A for the category, and column B for the total amount. What I did was that I made a separate table with two columns. Hey guys, I figured it out so I'll just post it here so hopefully anyone that needs help can benefit from my answer. Since this thread is asking how to do it in Numbers, please keep this thread open. Is there a way to combine pie slices or categories? Or is there a better way to accomplish this?Įdit: I realized just now that someone else in another thread is asking how to do this same task, except in Excel. I really just want one pie slice for Dining, one for Cellphone, etc. Numbers makes the pie chart but puts every individual expense into a separate slice, so I end up getting multiple pie slices that all say "Dining" and so forth. I would like to create a pie chart by expense type (ie, Toiletries, Dining, Cellphone, etc), but Numbers wants to treat each line item as a separate expense, even though many of them share the same name.
I have a spreadsheet with several lines of expense data, where each line item falls into one of many expense categories. Hey everyone, I'm new to using Numbers and spreadsheet things, so I was wondering if you could help me with making a chart.
0 kommentar(er)
