Checkbook register

[Alpha]

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

 

[mcescher]

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

Perhaps you could sort by the category, and then find the subtotals
for each catagory. No programming required.

Hope this helps,
Chris M.

 

[Jef Gorbach]

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

autofilter for the expense then select the amounts and see what the
status bar shows?

 

[J_Knowles]

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,