|
Sum by month
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 |
Sum by month
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 |
Sum by month
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 |
Sum by month
=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 |
Sum by month
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 |
| All times are GMT +1. The time now is 10:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com