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 OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200608/1