dsum

  • Thread starter Thread starter PaulOakley
  • Start date Start date
P

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
 
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?
 
Back
Top