Hello
i have a slight issue with trying to summarise of raft of rowed data as enclosed
I need to summarise by month where currently the database is by week - I have been trying to use Sum Product but this doesn't work - issue is it not only needs to summarise by month across thecolumns but also by factory by row
could anyone please help with this ?
thank you
peterSumProductProblem.xls
hi Perch, try:
=SUMPRODUCT(($D$3:$K$3=D$20)*($D$5:$K$14)*($C$5:$C$14=$C21))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Is this what you are trying to do?
Formula:
Please Login or Register to view this content.
Where M$3 has the grouping dates.
[EDIT]
Silly me, never noticed the bit below your table, go with Ben.
Just for another, but longer, way to approach the problem.
See the attached workbook
Last edited by Marcol; 03-01-2013 at 07:24 AM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
marvellous thank you !!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks