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