See attachment, hope it helps.
dcd123 Wrote:
=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?
+-------------------------------------------------------------------+
|Filename: Column.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3843 |
+-------------------------------------------------------------------+
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=469277