Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a formula question. Can someone help me?
I set up an electronic checkbook on Excel and I categorized my
purchases/debits. I want to sort out all the different purchases/debits and total each of them on another worksheet. I have no clue what formula functions to use or even how to go about this. Can someone please help me figure out how to set up the formula? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a formula question. Can someone help me?
ladyinchainmail;364671 Wrote: I set up an electronic checkbook on Excel and I categorized my purchases/debits. I want to sort out all the different purchases/debits and total each of them on another worksheet. I have no clue what formula functions to use or even how to go about this. Can someone please help me figure out how to set up the formula? HOW TO GET FURTHER HELP WITH A WORKBOOK For further help with it why not join our forums (shown in the link below) it's completely free, if you do join you will have the opportunity to add attachments to your posts so you can add workbooks to better illustrate your problems and get help directly with them. Also if you do join please post in this thread (link found below) so that people who have been following or helping with this query can continue to do so. :) -- Pecoflyer Cheers - ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=102184 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a formula question. Can someone help me?
ladyinchainmail -
one way would be to select the entire area and choose Data, Filter, Autofilter. then you'd be able to choose which debits you want to see and it would list them. caution - make sure you list all the debits the same way every time - i.e. clothes cleaning clothes cleaning clothes cleaning NOT cleaning clothes dry cleaners clothes cleaning because the autofilter will see each different entry as one separate entry. if they are all listed the same it will show them all to you, then you can sum just the ones that are showing. hope that helps. :) susan On Jun 1, 3:40*am, ladyinchainmail wrote: I set up an electronic checkbook on Excel and I categorized my purchases/debits. *I want to sort out all the different purchases/debits and total each of them on another worksheet. *I have no clue what formula functions to use or even how to go about this. *Can someone please help me figure out how to set up the formula? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a formula question. Can someone help me?
ladyinchainmail,
The bottom line is - don't use formulas, use a pivot table. Select all your data, the choose Data / Pivot table... and click OK. Then drag the description button to the row field, and the amount to the data field. Excel will automatically create a summary table with totals based on your purchase debit descriptions. HTH, Bernie MS Excel MVP "ladyinchainmail" wrote in message ... I set up an electronic checkbook on Excel and I categorized my purchases/debits. I want to sort out all the different purchases/debits and total each of them on another worksheet. I have no clue what formula functions to use or even how to go about this. Can someone please help me figure out how to set up the formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula question | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) | |||
formula question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
"IF" formula question | Excel Worksheet Functions |