Hi. I am currently working on a personal balance sheet. On one tab, I basically have my ledger of accounts listing the date of the transaction, the description, the amount debited, the amount credited, and the classification of purchase.
I would like to create a formula on a separate tab that would sum all of the "Gas" items for the each month.
Please see attachment
Forum Question.JPG
From this data, I would get the following sums for "Gas:"
March 2013 = -85.00
September 2013 = -86.00
I was able to create two sumif formulas, but I cannot seem to combine them so that they meet both the data range and the classification criteria.
Thanks,
Jackie
Bookmarks