dsum

[PaulOakley]

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

 

[optionbase1]

could try adding dsum's together?

if not try an array function

=sum(if((A1:A200=weekstartdate1)*(A1:A200=weekstartdate2)*(A1:A200=weekstartdate3)*(A1:A200=weekstartdate4)*(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?