I am working on a concrete pour summary, I would like to have the specific codes on each tab be affected from one summary page. So when I enter a certain number on sheet 1 , it will affect that same number section that is on a different sheet. It will be adding a certain amount to that code section every time its entered. What functions need to be used to make this work..?
I hope I explained this well enough.. Any help will be appreciated.
Thanks
Hi, could you try upload a sample spreadsheet with expected result and description?
_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved
Alvin
Attachment 288736
Hope this helps
Use SUMPRODUCT
For example in Building 1 E5
=SUMPRODUCT(Summary!$J$3:$J$12,--(Summary!$E$3:$E$12=C5),--(Summary!$I$3:$I$12=B5)) copied down
See attached
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi and welcome to the forum
Is this what you are looking for? In Building1 E5, copied down...
=IFERROR(INDEX(Summary!$H:$H,MATCH($B5*1,Summary!$I:$I,0)),"Not Found")
If you structure your other tables to start in the same cell each time (Building1 starts in B4, but Building2 starts in C5), then you can just copy that to all sheets
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Attachment 289593
Second Example
Hi KaylaMarie,
Two of your three tabs had a trailing space so watch for that, in the meantime you could try this: Kayla.xlsm
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks