Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summarizing category
Yo;
I have a sheet with two columns (Of significance), one denotes a dollar amount, and the other an expense category. Now I want another field, seperate from the above table, to print the sum of all the dollar amounts from a particular category; i.e. for each row in table; if ColumnA = "x", return the ColumnB I'm a relative novice to spreadsheets, so be clear in your explanations. Excel 2003. Cheerio, SigmaX |
#2
|
|||
|
|||
Summarizing category
It sounds like you want a SumIf formula:
Suppose your categories are in A1:A4 and your dollars are in B1:B4 as follows: A B 1 cat1 9 2 cat2 2 3 cat1 3 4 cat3 4 5 6 cat1 12 where the formula in B6 is: =SUMIF(A1:A4,A6,B1:B4) Art "SigmaX" wrote: Yo; I have a sheet with two columns (Of significance), one denotes a dollar amount, and the other an expense category. Now I want another field, seperate from the above table, to print the sum of all the dollar amounts from a particular category; i.e. for each row in table; if ColumnA = "x", return the ColumnB I'm a relative novice to spreadsheets, so be clear in your explanations. Excel 2003. Cheerio, SigmaX |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Bar Chart Category Axis Problem | Charts and Charting in Excel | |||
Only one colum of stack graph shows category label - problem | Charts and Charting in Excel | |||
Automatic Sum by Category (SumIf extension) | Excel Discussion (Misc queries) | |||
Category subtotalling | Excel Discussion (Misc queries) | |||
Rank() based on category | Excel Worksheet Functions |