Bit of help required.

[PaulOakley]

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,

[Jim Thomlinson]

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
>
>

[Gareth]

It may be useful to look at the weeknumber.

e.g.

WeekNumber of DateRquired =Weeknumber of Cell
And Year of DateRequired = Year of Cell

You need the Analysis addin installed if you want to use the WEEKNUM
function.

HTH

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,
>
>