mmartens12 via OfficeKB.com
Guest
Re: Growing range within a Sumproduct.
That is pretty slick! Thanks.
I followed the directions on that website you gave me and created some
dynamic ranges. My formulas work great with one dynamic range but gets a N/A
error when i put another range into the formula.
New
=SUMPRODUCT((MONTH(Dates)=MONTH($A19))*(YEAR(Dates)=YEAR($A19))*(Systems=O$18)
)
Old
=SUMPRODUCT((MONTH(Data!$A$5:$A$645)=MONTH($A20))*(YEAR(Data!$A$5:$A$645)
=YEAR($A20))*(Data!$E$5:$E$645=O$18))
Here is my Dynamic range
=OFFSET(Data!$E$4,1,0,COUNTA(Data!$E:$E),1)
The results:
New = N/A
old = right answer
What can i do?
--
Message posted via http://www.officekb.com
Bookmarks