Im using this formula: =SUMPRODUCT(--(C6:C403="??"),--(D6:D403="??"))
which works well, however where the "??" are placed i would like to
enter a cell location i.e "A6" which will use whatever text is in the
cell to perform the sum. Is this possible? it would save alot of time
rather than changing criteria in the formula everytime
Help is much appreciated
--
SamGB
------------------------------------------------------------------------
SamGB's Profile:
http://www.excelforum.com/member.php...o&userid=31263
View this thread:
http://www.excelforum.com/showthread...hreadid=516363