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