Ok, Ive completed my check register and it works great. It isnt Quicken but its nice and it works well.

However, I want my check register to perform a couple tricks like displaying the current totals for each category and the totals of each category for any specified month.

I can display the current totals using the formula below, what I need is a formula to display the total of each category for any specified month.

=SUMIF(E:E,=School Tuition,F:F)

Column B = Date the check was written (1/12/2005)
Column E = the Category School Tuition, Auto Loan, etc.
Column F = the $ amount of check.

Any help with a formula would be appreciated. Thanks