=SUMPRODUCT(('Sales thru 9-16-05'!$1:$1=Summary!$B2)*('Sales thru
9-16-05'!B$2:B$1433=TRUE))

While filling down, I want the reference in the second criteria to
change from B$2:B$1433 to C$2:C$1433, then in the next cell down
D$2:D$1433, etc.

Does that help?


--
dcd123
------------------------------------------------------------------------
dcd123's Profile: http://www.excelforum.com/member.php...o&userid=25396
View this thread: http://www.excelforum.com/showthread...hreadid=469277