LinkBack URL
About LinkBacks
In the attached sample I am able to get totals by catagory and year, but I also want to seperate them by month. So far I have not had much success.
Any ideas?
Jim O
In the attached sample I am able to get totals by catagory and year, but I also want to seperate them by month. So far I have not had much success.
Any ideas?
Jim O
Last edited by JO505; 02-19-2013 at 04:32 PM.
Jim
Have you tried a pivot table?
You can have Job as a row field, Date grouped by year and month as a column field and Sum of Price for the data field.
If posting code please use code tags, see here.
Norie,
I am not sure a pivot table is the answer as this is only interim step in a workbook. I was hoping for a formula that would do the job.
Thanks for your reply
Jim O
Jim
A pivot table would be able to summarise and group the data as you want.
I tried it with the attached workbook and it worked fine - though I think there was some data missing.
How wouldn't a pivot table work for you?
What is the next step?
In C4
Copy across and down
=SUMPRODUCT(--(TEXT(Job!$C$2:$C$40,"mmm")=C$3),--(YEAR(Job!$C$2:$C$40)=C$2),--(Job!$E$2:$E$40=$B4),Job!$G$2:$G$40)
Life's a spreadsheet, Excel!
Say thanks, Click *
Ace,
That is perfect.Thank you for your input.
Jim O
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks