=SUMPRODUCT(((YEAR(A6:A100)=2009)*(MONTH(A6:A100) =7))+((YEAR(A6:A100)=2010)*(MONTH(A6:A100)<=6))*(B 6:B100="u")*C6:C100)
or
=SUMPRODUCT((TEXT(A6:A100,"yyyymm")="200907")*(TE XT(A6:A100,"yyyymm")<="201006")*(B6:B100="u")*C6:C 100)
--
David Biddulph

"mePenny" wrote in message
...
I have this formula below that deals with finding calendar year. I need a
formula that does the same thing but for Fiscal Year (7/1/09 - 6/30/10).

=SUMPRODUCT((YEAR(A6:A100)=2009)*(B6:B100="u")*C6: C100)

Can anyone help? Would truly appreciate it!!!

Thank you
mePenny