View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
SamGB
 
Posts: n/a
Default SUMPRODUCT Help please


Isnt $C1:$C65536 and $D1:$D65536 a column anyway?

What i want to do is copy the formula into alot of decending cells, but
every time i copy down a cell the value increases by one which is what i
WANT. However the range also increase by one which i DONT want. Any
ideas??


--
SamGB
------------------------------------------------------------------------
SamGB's Profile: http://www.excelforum.com/member.php...o&userid=31263
View this thread: http://www.excelforum.com/showthread...hreadid=516363