How can I conditionally add up cells and display?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a summary list from source data - can you?? 1
How do I add variables 1
Converting amount($) of my expenditure into the base currency i wa 1
How to make different cells fill in automatically from one entry? 3
Drop down list - need to reference and populate another cell with 7
Help with conditionally unhiding columns 1
How do I tally numbers, of a specific expense category? 3
Transfering information to the next free cell in a column 1

Top