Hello.

I am trying to sum columns only with a specific week commencing date.
Is dsum the only way to do this? As i cannot get dsum to work. There
are often more than five week commencing dates that need to all be
added together.

Any ideas?

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

could try adding dsum's together?

if not try an array function

=sum(if((A1:A200=weekstartdate1)*(A1:A200=weekstar tdate2)*(A1:A200=weekstartdate3)*(A1:A200=weekstar tdate4)*(A1:A200=weekstartdate5),B1:B200))

where A:A contains your week start dates and B:B contains your column
to sum.

the * represents an AND
you can use a + to represent OR

You need to press and hold Ctrl+Shift when pressing Enter having typed
these formula to tell Excel that it is an array function. it should
then appear in the Formula bar with {} around it.

(note that if you either reference a whole column or use lots of these
in a spreadsheet you will absorb system resources; shouldn't be a
problem if you are using a few)

Have you considered a Pivot table?


--
optionbase1
------------------------------------------------------------------------
optionbase1's Profile: http://www.excelforum.com/member.php...o&userid=25212
View this thread: http://www.excelforum.com/showthread...hreadid=387997