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


--
duncan79
------------------------------------------------------------------------
duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=543243

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" a écrit
dans le message de news:
...

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


--
duncan79
------------------------------------------------------------------------
duncan79's Profile:
http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=543243

Have you thought about creating a Pivot table to allow for the split of the
data?
--
Thanks for your help -
Joe Mac


"Ardus Petus" wrote:

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" a écrit
dans le message de news:
...

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


--
duncan79
------------------------------------------------------------------------
duncan79's Profile:
http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=543243

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


--
duncan79
------------------------------------------------------------------------
duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=543243

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

HTH
--
AP

"duncan79" a écrit
dans le message de news:
...

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


--
duncan79
------------------------------------------------------------------------
duncan79's Profile:
http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=543243

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


Ardus Petus Wrote:
=MONTH(C14)=4 checks for April
=MONTH(C14)=5 " " May
=MONTH(C14)=6 " " June
etc

HTH
--
AP

"duncan79" a
écrit
dans le message de news:
...

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


--
duncan79

------------------------------------------------------------------------
duncan79's Profile:
http://www.excelforum.com/member.php...o&userid=30833
View this thread:
http://www.excelforum.com/showthread...hreadid=543243



--
duncan79
------------------------------------------------------------------------
duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=543243