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

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion