Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbook register
If I have a checkbook ledger and I want to find the total in a category. For
example, I have Auto Insurance, Gas bill, etc. I want to know how much I have payed in Gas until now, lets say six months into the year. What formula or method do I use? Tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbook register
Let say your data is in A1:G100 and column G has dollars spent. Turn on
AutoFilter In the "Category" column pick Gas and in the "Date" column filter for 6 months. In cell G102, place this formula for summing dollars that are filtered. =SUBTOTAL(9,G2:G100) This will give you the subtotal for gas for a 6 month period. You could then copy G102 and paste special - values into table of expenses for 6 months. HTH, -- Data Hog "Alpha" wrote: If I have a checkbook ledger and I want to find the total in a category. For example, I have Auto Insurance, Gas bill, etc. I want to know how much I have payed in Gas until now, lets say six months into the year. What formula or method do I use? Tony . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checkbook register | Excel Discussion (Misc queries) | |||
checkbook register | New Users to Excel | |||
Checkbook Register | Excel Discussion (Misc queries) | |||
Spreadsheet like checkbook register | New Users to Excel | |||
checkbook register template | Excel Programming |