David, what is the difference between the two formula's?

"David Biddulph" wrote:

Can anyone give me a clue why occasionally I lose all my line feeds?

What the message ought to say (if it doesn't lose the line feeds again) is:
Sorry. Misplaced parentheses in the first formula. It should have been
=SUMPRODUCT(((YEAR(A6:A100)=2009)*(MONTH(A6:A100) =7)+(YEAR(A6:A100)=2010)*(MONTH(A6:A100)<=6))*(B6: B100="u")*C6:C100)

--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in
...
=SUMPRODUCT(((YEAR(A6:A100)=2009)*(MONTH(A6:A100) =7))+((YEAR(A6:A100)=2010)*(MONTH(A6:A100)<=6))*( B6:B100="u")*C6:C100)
or
=SUMPRODUCT((TEXT(A6:A100,"yyyymm")="200907")*(T EXT(A6:A100,"yyyymm")<="201006")*(B6:B100="u")*C6: C100)

--
David Biddulph

"mePenny" wrote in
...
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



--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Sorry. Misplaced parentheses in the first formula. It should have been
=SUMPRODUCT(((YEAR(A6:A100)=2009)*(MONTH(A6:A100) =7)+(YEAR(A6:A100)=2010)*(MONTH(A6:A100)<=6))*(B6: B100="u")*C6:C100)--David
Biddulph"David Biddulph" <groups [at] biddulph.org.uk wrote in
...= SUMPRODUCT(((YEAR(A6:A100)=2009)*(MONTH(A6:A100)= 7))+((YEAR(A6:A100)=2010)*(MONTH(A6:A100)<=6))*(B6 :B100="u")*C6:C100)
or=SUMPRODUCT((TEXT(A6:A100,"yyyymm")="200907")* (TEXT(A6:A100,"yyyymm")<="201006")*(B6:B100="u")*C 6:C100)
-- David Biddulph "mePenny" wrote
in ...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



.