It is hard to tell from your question exactly what you want but it sounds
like a SumProduct formula might be in order. Take a look at this link...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...
Jim Thomlinson
"PaulOakley" wrote:
Hey People,
I am trying to set a calculation statement so that it adds together
only certain week commencing dates. For example I need a script to go
to a seperate sheet and recognise all of the week commencing dates of
the 18/07/2005 for example and then from the rows within the commencing
dates perform a calculation..
I am sure it is possible, I think i should be using DSUM but cant seem
to get it to work? Any advice?
Thanks in advance,
--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103
View this thread: http://www.excelforum.com/showthread...hreadid=387983