How do I combine data in one spreadsheet from multiple spreadsheets?

**aprl** · 03-24-2014, 12:16 PM

I have multiple spreadsheets that I use and am trying to condense data into yet another "administrator" spreadsheet. Basically...trying to count the amount of accounts certain users have been assigned and have completed. I am using a SUMPRODUCT formula that links to each seperate spreadsheet and then populates the data in the new spreadsheet. Is this the better way? I feel as though having a "Sumproduct" formula in each individual cell of the administrator sheet is overkill. Thanks in advance. As you can probably tell, I am not advanced in Excel...but I do know my way around a bit.

Thank you.

**olwy** · 03-24-2014, 12:24 PM

Hi, I did not understand a lot... it is always nice you insert a file with example - raw data and part of desired result. In general, have a look at sumifs function or vlookup. Could you have at your Administrator sheet some fixed data? Or it is whole based on your previous sheet - changing everytime?

**bebo021999** · 03-24-2014, 12:29 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**aprl** · 03-24-2014, 12:37 PM

olwy...I will try to post a sample on here. The Administrator sheet will constantly change as the status of the account and employee assigned to it is adjusted in the multiple spreadhsheets where the data comes from. Thank you for your response.

**olwy** · 03-24-2014, 12:44 PM

Yes, sounds as a nice problem to me. Add just some rows, just to be able to get a picture of how it looks like. And if really the source data is totally different, add two sets of data-source. In my case, I always have some information the same (as customer name) and changes are just in sales, delivery data, etc. Good luck (tommorow)

**aprl** · 03-24-2014, 12:56 PM

I have attached the example to my original post. Thank you in advance for any help...and for your patience. This forum stuff is all new to me. I will be glad to answer any questions.

**olwy** · 03-25-2014, 04:24 AM

summarizing negotiators - solved.xlsx
Hello, thanks for your trust. About the forum - rules here is quite strict, on the other hand, thanks to that - it works so well. In general, if somebody helps you, it is nice to add him a reputation or leave some comments. Get reasonable name of your post and try to upload sample of data each time. (for example, I do everything in Czech localization, so I have no idea how to use half of mine function - with a different translation, there could be a different syntaxt as well. But - saving it - it is OK for everybody. And, it is much easier to explain it.

About your problem: have a look at it. Basic formula is for your 1352 main (this, you will need to change for each sheet).
Advanced formula is in 1300 main - this could be used everywhere if you add just sheet name into line 1. Countifs was used here.
Good luck.