Home |
Search |
Today's Posts |
#1
|
|||
|
|||
scanning a table?
ok so here's what ive got table of accouting stuff 4 columns column 1 : Date column 2 : Category (eg. groceries, laundry, allowance) column 3 : shop name column 4 : amount in dollars and then a whole bunch of rows with a variable for each column what i want to do is make a cell with a formula that will add up all the amounts in dollars of a certain category eg. if a row's category value is groceries, then i want that amount in dollars for that row to be added to the value in dollars in a cell that adds up all the amounts for every row where the category is groceries hope i put it clear enough... can this be done in excel? thanks in advance -- bobthedinosaur ------------------------------------------------------------------------ bobthedinosaur's Profile: http://www.excelforum.com/member.php...o&userid=28160 View this thread: http://www.excelforum.com/showthread...hreadid=476825 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Data In Pivot Table | New Users to Excel | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
table | Excel Discussion (Misc queries) | |||
table | Excel Worksheet Functions |