Hi,

I'm trying to compile year end totals across 24 worksheets into one
sheet for last year. Each worksheet has a category column that
describes individual entries.


DATE NUM DESC CATEGORY DEBIT(-) CREDIT(+)
BALANCE
4 - 12/15/12 SAL Sales SalesMN
176.18 1176.18
5 - 12/17/12 DCD Quickbooks Accounting 149.99
1026.19
6 - 12/18/12 ATF Inventory Inventory 324.07
702.12

Here's the formula I've tried but it won't total the year across the
sheets. Works great on just one sheet. Without YEAR.

=SUMIF(YEAR(D4:D100,"=Accounting",E3:E100))

Any help would be appreciated.

Thank you, thank you, thank you.