LinkBack URL
About LinkBacks
Hi all
I have person incomes from different source in different sheet. I want total income. also some person incomes in one sheet should be sum. please see sample file. my data is very bulk.
Thanks
Hi all
I have person incomes from different source in different sheet. I want total income. also some person incomes in one sheet should be sum. please see sample file. my data is very bulk.
Thanks
Last edited by alireza123456; 08-04-2016 at 02:28 PM.
What do you want to get from the sample?
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
sum of income for each id in all sheet.
in one sheet one id may have some income from different sources.
with a 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.
Thank
i have multiple sheet not one sheet.
Notice my main language is not English.
add all data in 1 worksheet and after that a pivot table.
You can use a column (e.g. A) with the name of the sheet in it, so you can use that information also in the pivot table.
i have more than 14 sheet and 1 million entry.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks