GS wrote:
Pamela Rease presented the following explanation :
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.

Are there separate sheets for each category? If so then IMO it's a bad
design! There's no reason why you shouldn't use a single sheet for all
categories plus a summary sheet. The summary sheet would collect from
each category, and could be set up to show by month/QTR/YTD.

On the other hand.., I see the name "Quickbooks" in your list and so
begs me to ask why you don't use that app to generate a custom report
for the fiscal/calendar year?<g


Thanks for your reply. Bad design is right. But I inherited it.

No. There are separate sheets for each month with categories dispersed
randomly on each monthly sheet. What I'm trying to do is create a
yearly summary sheet with individual category totals for the year.

And Quickbooks was just a demonstrative entry.