Transfer information

In sheet: Carrots 2007 YTD,

Put in B2:
=SUMPRODUCT(('Carrot 2007'!$B$2:$B$100=$A2)*('Carrot
2007'!$E$2:$E$100=B$1),'Carrot 2007'!$G$2:$G$100)

Copy B2 across to M2, fill down. The simple SUM that you have in N2 down
(for YTD) suffices. For a neater look, we could suppress the display of
extraneous zeros in the sheet via clicking Tools Options View tab
Uncheck "Zero values" OK.

P/s: For the mutual benefit of all, kindly put in any new queries as **new**
postings.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Aggie G" wrote in message
...
Ok I have another question about this same spreadsheet. What I am trying
to
accomplish is create an accumulative amount of awarded hours for each
employee in my company for each MTD and YTD. I want the Carrots YTD
worksheet
to read from the Carrot 2007 worksheet and enter in the total hours for
each
month and provide a total for the year. Can you help me do this? Below is
the
link to my document.

http://www.savefile.com/files/651790