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 |
#2
|
|||
|
|||
scanning a table?
Place this formula in your desired cell, adjust the listed ranges to meet your needs: =SUMIF(B2:B100,"=Groceries",D2:D100) where B2:B100 is your Category column and contains "Groceries" and D2:D100 is your amount column. Good Luck -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=476825 |
#3
|
|||
|
|||
scanning a table?
Hi Bob
Your data is ideal for summary with a Pivot Table. This would allow you to easily summarise your data by Category (and by Month if you want). For help on how to set up Pivot Tables take a look at http://peltiertech.com/Excel/Pivots/pivotstart.htm Regards Roger Govier bobthedinosaur wrote: 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 |
#4
|
|||
|
|||
scanning a table?
Thanks Guys! -- bobthedinosaur ------------------------------------------------------------------------ bobthedinosaur's Profile: http://www.excelforum.com/member.php...o&userid=28160 View this thread: http://www.excelforum.com/showthread...hreadid=476825 |
Reply |
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 |