If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I conditionally add up cells and display?
I'm new to excel...so sorry if this is simple.. I can't figure it out...
I want to add up expeneses on one worksheet and display on another based upon what category they are. Sheet 1 Column a is description, B = amount, c=category from drop down list (sheet 2 column list i.e. vehcile, travel, etc.). Each row repersents a different expenses. It would be great to find a simply way to allow the cell to the right of each item on the drop down list to show the total amount of all expenses of that type. Don't know if this is possible or easy to do. Any help would be greatly appreciated. Thanks, Marty |
#2
|
|||
|
|||
=SUMIF(Sheet1!C:C,A1,Sheet1!B:B)
where A1 is the start of the DV list. -- HTH Bob Phillips "Marty" wrote in message ... I'm new to excel...so sorry if this is simple.. I can't figure it out... I want to add up expeneses on one worksheet and display on another based upon what category they are. Sheet 1 Column a is description, B = amount, c=category from drop down list (sheet 2 column list i.e. vehcile, travel, etc.). Each row repersents a different expenses. It would be great to find a simply way to allow the cell to the right of each item on the drop down list to show the total amount of all expenses of that type. Don't know if this is possible or easy to do. Any help would be greatly appreciated. Thanks, Marty |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Display contents of a specific cell even if a group of cells is mo | Larry Heine | Worksheet Functions | 5 | December 4th, 2008 10:33 PM |
Display -vs- Print Format in Cells | Willie | New Users | 2 | June 8th, 2004 08:20 PM |
Display # from another cell if another cell's # is within range | MAK | Worksheet Functions | 3 | March 10th, 2004 04:37 PM |
Conditionally display an object in a cell ? | Mark Parent | Worksheet Functions | 2 | February 19th, 2004 11:05 PM |
line graph display 0 for blank cells | Mark | Charts and Charting | 1 | January 27th, 2004 11:48 PM |