Sum by month

[duncan79]

I have a file i'm using to calculate invoices and totals, in the summary
page i want to create a month by month summary

i have read the excel help and i cant find what i need, I am using the
DSUM function to calculate a running total which works fine.

eg: =DSUM(C$14:G$1015,"Amount",C$1:G$2)

but how would i get my sheet to add all the invoices together revcieved
in one month if all the dates appear in one column???

and then combine this with my DSUM function to split the incoices into
the relevant cost centres???

thanks in advance for any help... this forum has saved me hours of
headaches and rage outbursts!! It rules!!

 

[Ardus Petus]

Assuming your invoice date is in column C
Create a selection ctiterium (in range C1:G2, extended if needed)
Header (in row 1: empty)
Criterium: =MONTH(C14)=4

HTH
--
AP


"duncan79" <[email protected]> a écrit
dans le message de (e-mail address removed)...

 

[Guest]

Have you thought about creating a Pivot table to allow for the split of the
data?

 

[duncan79]

Ok thanks i'm going to us the DSUM function for this again but how does
the =MONTH(C14)=4 expression youve posted work i cant seem to get my
head around it what are the expressions for each month???

 

[Ardus Petus]

=MONTH(C14)=4 checks for April
=MONTH(C14)=5 " " May
=MONTH(C14)=6 " " June
etc

HTH

 

[duncan79]

I can see how this will check for the date in cell c14 how do i ammend
this to check a whole row??

and also if i use a standard date call =MONTH(4) or from a relative
cell it inserts the month into the day part of the date!!????
regardless of how the date is formatted

anyhelp would be great, maybr i'm slow but i've been trying to work
this out for about 2 days