LinkBack URL
About LinkBacks
I posted before but struggling with this site too lol.
Trying to get column O to add up all the sheets. The present formula includes in cell O15 includes one sheet.
Thanks,
Dale
I posted before but struggling with this site too lol.
Trying to get column O to add up all the sheets. The present formula includes in cell O15 includes one sheet.
Thanks,
Dale
try this, copied down...
=SUM('101:125'!O15)
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
1) On the Facilities sheet, in column S starting at S1, list the sheet names that you want to sum.
S1: 101
S2: 102
.
.
.
.
S14: 125
2) In cell O15, enter this array formula:
=SUM(SUMIF(INDIRECT($S$1:$S$14&"!B:B"), B15, INDIRECT($S$1:$S$14&"!O:O")))
...confirm it by pressing CTRL-SHIFT-ENTER to activate the array. You will see curly braces { } appear around your formula to indicate the array is active and the first value of 13,000 should appear.
3) Copy O15 down the column O as needed.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This would work but doesn't as the categories in column B are staggered so a VLookup of some kind is needed?
JBeaucaire, I tried it and it just did not work for me.
Thanks for trying,
Dale
You can do it the low budget way: =VLOOKUP($B16,'101'!B2:P133,14,)+VLOOKUP($B16,'102'!B2:P133,14,)+VLOOKUP($B16,'103'!B2:P133,14,)+... or SUM(vlookup($B16,'101'!B2:P133,14,),VLOOKUP($B16,'102'!B2:P133,14,),....)
63Willys, Neither worked for me. Guess I am on the verge of giving up.
Dale
some way same as JB with sumproduct
CAPEX REPORT AUG 2012 1 Final dp (1).xls
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
I don't see what the problem is. Here's your file back with those exact steps installed from post #3.
Looks all good to me. I never used the "outer parenthesis"{} and plus (stupid mistake) I put S1:101 etc. into cell S1 on down lol
Thanks,
DP
If that takes care of your need, please select Thread Tools from the menu above and mark the thread as solved. Thanks.
Thanks all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks