I'd like to use the SUMPRODUCT (or other formula) with certain conditions to show results in the similar shape of a pivot table.
I have a database "clients, cost-centers, months, revenues". For some of the clients we may have multiple cost-centers. I need the formula to show revenues depending on : clients, cost-centers, months alltogether in the same table, eventually in the matrix on the attached excel.
Thanks for your support!
Looking forward to hearing from you.
Very nice picture!
May i ask you something? Can you work in a picture?
If NO, then pls upload a sample workbook. Not a picture.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I agree with Fortis1991
But I have a second question.
Why would you like to have a sumproductformula, if you now the possibilities of an pivot table?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I can't find here any option to attach an excel file.
Basically, my case contains more clients than allocated cost-centers (eg : 500 clients and 10 center-costs) and I want to calculate and display automatically the revenues for each clients/cost-centers/months.
Yes, pivot table is a solution, but I was wondering if I can use any formula to substitute pivot table.
Thanks,
Mariux
Cross posted:
http://www.mrexcel.com/forum/excel-q...vot-table.html
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Finally, I've found the options to attach sample
Database : A2:D14
Pivot table (example) : J4:M23
Range to calculate : E19:H29
Thanks,
Mariux
Thanks, it was me that opened that thread
Originally Posted by Mariux
Thanks, it was me that opened that thread
And as i see you are proud for this! It is shame on you!
So this is a message for you!
http://www.excelguru.ca/content.php?184
contents deleted
Last edited by daddylonglegs; 01-05-2013 at 11:52 AM.
@Mariux
1) You don't give an answer to my question.
2) I don't like the way you react on a college member (who's try-ing) to help you.
If your talking about decent manners, take an example to yourself.
3) Is it pointing you why cross posting, without telling us, that bothering you?
If so, you don't read the given link well enough!!
content deleted
Last edited by daddylonglegs; 01-05-2013 at 11:52 AM.
Please Login or Register to view this content.What a weird reaction !!Please Login or Register to view this content.
You could just give an anwer to my question.
If the Moderators of the forum let's you to react in this way without to do anything, then i have to think again for my Contribution in this forum.
I say again:
It is shame on you!
content deleted
Last edited by daddylonglegs; 01-05-2013 at 11:53 AM.
Hello Mariux, you joined the forum today but perhaps you haven't read our rules - please read them - you've broken at least 2 so far - this thread is closed
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks