What's new
By:
USCHO Fan Forum

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

  • The USCHO Fan Forum has migrated to a new plaform, xenForo. Most of the function of the forum should work in familiar ways. Please note that you can switch between light and dark modes by clicking on the gear icon in the upper right of the main menu bar. We are hoping that this new platform will prove to be faster and more reliable. Please feel free to explore its features.

RPI 2013/14 Part III: Maximum Overdrivel

Re: RPI 2013/14 Part III: Maximum Overdrivel

Have been trying to figure this out and cannot but since there seems to be a few people on here with excel experience maybe one of you and help me out.
I have a workbook with over 60 different sheets in it for truck inventory. I am trying to have a sheet that will have the total off all the sheets by using a sumif or other function since the data on all the sheets is the same. For example, all the sheets have the following headings for each truck:

Inventory Item Qty Cost Total

Now I want a totals sheet for all the trucks without having to do =sheet1 a1 + sheet2 a1 + etc. for each inventory item.
Anybody know how to do this with the sumif function or other function.
 
Re: RPI 2013/14 Part III: Maximum Overdrivel

Stay@homeDad said:
Have been trying to figure this out and cannot but since there seems to be a few people on here with excel experience maybe one of you and help me out.
I have a workbook with over 60 different sheets in it for truck inventory. I am trying to have a sheet that will have the total off all the sheets by using a sumif or other function since the data on all the sheets is the same. For example, all the sheets have the following headings for each truck:

Inventory Item Qty Cost Total

Now I want a totals sheet for all the trucks without having to do =sheet1 a1 + sheet2 a1 + etc. for each inventory item.
Anybody know how to do this with the sumif function or other function.
Click to expand...

Would you be opposed to doing a macro? You could do a for-loop on the sheets.
 
Re: RPI 2013/14 Part III: Maximum Overdrivel

I am sort of glad we ended up with the 7th seed instead of the 6th. I know how crazy the first round gets but we played Dartmouth well and if we get them in the 2nd round, Colgate pretty decent this year. Im totally asking for it by saying this, but I don't see why we cant make a run and end up in Lake Placid.
 
Re: RPI 2013/14 Part III: Maximum Overdrivel

fishcore12 said:
I am sort of glad we ended up with the 7th seed instead of the 6th. I know how crazy the first round gets but we played Dartmouth well and if we get them in the 2nd round, Colgate pretty decent this year. Im totally asking for it by saying this, but I don't see why we cant make a run and end up in Lake Placid.
Click to expand...

I was just saying in another thread that we've been successful against Dartmouth this year, 11-3: one game was back in nearly November when we were looking good and the other was in late January where we turned around a 4-game loosing streak. Similarly we had a dominating win over 'Gate back in our better days of November and a 1-1 tie last month. Of course, anything could happen but we certainly have an honest shot at Lake Placid. Let's go RED!
 
Re: RPI 2013/14 Part III: Maximum Overdrivel

Stay@homeDad said:
Have been trying to figure this out and cannot but since there seems to be a few people on here with excel experience maybe one of you and help me out.
I have a workbook with over 60 different sheets in it for truck inventory. I am trying to have a sheet that will have the total off all the sheets by using a sumif or other function since the data on all the sheets is the same. For example, all the sheets have the following headings for each truck:

Inventory Item Qty Cost Total

Now I want a totals sheet for all the trucks without having to do =sheet1 a1 + sheet2 a1 + etc. for each inventory item.
Anybody know how to do this with the sumif function or other function.
Click to expand...

If I understand your question correctly:

If all the sheets have exactly the same layout, and you want to sum the total of the all the same cell on every sheet you can simply use the sum function.

suppose you want to add all of cell D5 from every sheet:


=sum('Sheet1'!D5:'Sheet60'!d5) where Sheet1 is the name of the first sheet and Sheet60 is the name of the last sheet.

You also can use the indirect function in some of those cases. The indirect function allows you to write a formula that uses cell entries as formula terms.

So if cell c5 reads 'sheet7!'H8, and you use the formula =indirect(c5) the result is the value from cell 'sheet7'!h8
 
Last edited:
Re: RPI 2013/14 Part III: Maximum Overdrivel

fishcore12 said:
I am sort of glad we ended up with the 7th seed instead of the 6th. I know how crazy the first round gets but we played Dartmouth well and if we get them in the 2nd round, Colgate pretty decent this year. Im totally asking for it by saying this, but I don't see why we cant make a run and end up in Lake Placid.
Click to expand...

I thought the same thing about Brown last year. I also do recall that we played this same team five years ago in the playoffs, and an upset also occurred (of course, we were the underdogs). Anything can happen, we just must play hard. A 500 season is still doable.
 
Re: RPI 2013/14 Part III: Maximum Overdrivel

I'm not getting ahead of myself but love the match up and potential 2nd round match ups if we advance. 3 points vs gate and Cornell so far this year
 
Re: RPI 2013/14 Part III: Maximum Overdrivel

fishcore12 said:
I am sort of glad we ended up with the 7th seed instead of the 6th. I know how crazy the first round gets but we played Dartmouth well and if we get them in the 2nd round, Colgate pretty decent this year. Im totally asking for it by saying this, but I don't see why we cant make a run and end up in Lake Placid.
Click to expand...


As fans, I also see how our potential progression in the playoffs looks promising based on our play against these teams during the regular season.

Everyone steps up for the playoffs. Can we step up incrementally more than these other teams do?

Let's also hope Scotty can get even hotter than he has been lately!
 
Re: RPI 2013/14 Part III: Maximum Overdrivel

lugnut92 said:
Sorry about dropping the ball on this one the last couple of days. I was hosting friends that came down for the Yale game so I've been a bit busy.
Click to expand...

Higgs has 31.8% of the fan vote currently. If this holds up, it will be worth 1/3 of that or about 10.6% of the total vote. Considering that there are ten candidates, 10.6% is very significant.

So keep voting! :D
 
Re: RPI 2013/14 Part III: Maximum Overdrivel

FlagDUDE08 said:
I thought the same thing about Brown last year. I also do recall that we played this same team five years ago in the playoffs, and an upset also occurred (of course, we were the underdogs). Anything can happen, we just must play hard. A 500 season is still doable.
Click to expand...
Oh no you didn't. I seem to recall you betting me a beer that RPI would lose to Brown - which they did. I owe you that beer still. I haven't paid it yet because the people at the asylum said it would interfere with your meds. :p
 
You must log in or register to reply here.
Back
Top