Can you post your formula? Which part of the formula should be changed
by column as you drag it down?


dcd123 Wrote:
I have a worksheet that is using the sumproduct function based on
criteria on another sheet. I need to use the same function in other
cells so I am using the fill handle to bring it down, but I want one of
the criteria references to change by column, not by row.

Please help!!


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=469277