Chicago Fanatics Message Board • View topic - Adding data from different tabs in google sheets

View unanswered posts | View active topics

Board index » GENERAL BULLSHIT SECTION » GENERAL DISCUSSION

All times are UTC - 6 hours [ DST ]

Adding data from different tabs in google sheets

Page 1 of 1

[ 12 posts ]

Print view

Previous topic | Next topic

Author

Message

conns7901

Post subject: Adding data from different tabs in google sheets

Posted: Mon Feb 08, 2021 12:12 am

Joined: Wed Nov 30, 2005 11:36 pm
Posts: 19608

There has to be an easier way to tally stats from different games:

This is what I am doing right now:

=sum({Game1!B2;Game2!B2;Game3!B2;Game4!B2;Game5!B2;Game6!B2})

There has to be a way like in excel where you can just make it so it adds every cell from every tab between the first and last one so I don't have to type each individual game in the formula line.

This is how I did it in excel:

=SUM('Game1:TBA'!B2)

_________________

Frank Coztansa wrote:

conns7901 wrote:

Not over yet.

Yes it is.

CDOM wrote:

When this is all over, which is not going to be for a while, Trump will be re-elected President.

Top

blackhawksfan

Post subject: Re: Adding data from different tabs in google sheets

Posted: Mon Feb 08, 2021 5:38 am

Joined: Sun May 11, 2014 8:50 pm
Posts: 6349
pizza_Place: PizzaHut

Google sheets can't compete with excel. RIP Bill Gates

Top

a retard

Post subject: Re: Adding data from different tabs in google sheets

Posted: Mon Feb 08, 2021 9:15 am

Joined: Sun Jul 02, 2006 6:08 am
Posts: 7353
Location: Section 433
pizza_Place: 1. Homemade 2. Jewels

Set it up in Excel and then upload it to google.

_________________
"I honestly don't see a good bet on the board here."

Top

pittmike

Post subject: Re: Adding data from different tabs in google sheets

Posted: Mon Feb 08, 2021 9:37 am

Joined: Mon May 02, 2011 4:29 pm
Posts: 40895
Location: Everywhere
pizza_Place: giordanos

I can't imagine trying to use anything but Excel.

_________________
Elections have consequences.

Top

Frank Coztansa

Post subject: Re: Adding data from different tabs in google sheets

Posted: Mon Feb 08, 2021 10:12 am

100000 CLUB

Joined: Wed Feb 08, 2006 6:17 pm
Posts: 102662
pizza_Place: Vito & Nick's

Turn your Google sheets off then on again.

_________________

Joe Orr Road Rod wrote:

It's more fun to be a victim

Caller Bob wrote:

There will never be an effective vaccine. I'll never get one anyway.

Top

conns7901

Post subject: Re: Adding data from different tabs in google sheets

Posted: Mon Feb 08, 2021 11:29 am

Joined: Wed Nov 30, 2005 11:36 pm
Posts: 19608

a retard wrote:

Set it up in Excel and then upload it to google.

I did. Formula doesn't transfer.

_________________

Frank Coztansa wrote:

conns7901 wrote:

Not over yet.

Yes it is.

CDOM wrote:

When this is all over, which is not going to be for a while, Trump will be re-elected President.

Top

Douchebag

Post subject: Re: Adding data from different tabs in google sheets

Posted: Mon Feb 08, 2021 11:29 am

Joined: Tue Aug 19, 2008 3:03 pm
Posts: 43848

conns7901 wrote:

a retard wrote:

Set it up in Excel and then upload it to google.

I did. Formula doesn't transfer.

Pay an Indian guy 13 cents and have it done right.

_________________

Juice's Lecture Notes wrote:

I am not a legal expert, how many times do I have to say it?

Top

Frank Coztansa

Post subject: Re: Adding data from different tabs in google sheets

Posted: Mon Feb 08, 2021 11:34 am

100000 CLUB

Joined: Wed Feb 08, 2006 6:17 pm
Posts: 102662
pizza_Place: Vito & Nick's

Coons Shuld work on HIM SELF and be USing BLUEHOST???????????

_________________

Joe Orr Road Rod wrote:

It's more fun to be a victim

Caller Bob wrote:

There will never be an effective vaccine. I'll never get one anyway.

Top

a retard

Post subject: Re: Adding data from different tabs in google sheets

Posted: Mon Feb 08, 2021 1:28 pm

Joined: Sun Jul 02, 2006 6:08 am
Posts: 7353
Location: Section 433
pizza_Place: 1. Homemade 2. Jewels

conns7901 wrote:

a retard wrote:

Set it up in Excel and then upload it to google.

I did. Formula doesn't transfer.

Sorry, yeah it looks like Google does not have that functionality :oops:

https://stackoverflow.com/questions/210 ... readsheets

_________________
"I honestly don't see a good bet on the board here."

Top

City of Fools

Post subject: Re: Adding data from different tabs in google sheets

Posted: Mon Feb 08, 2021 4:08 pm

Joined: Thu Jun 26, 2008 8:22 am
Posts: 15198
pizza_Place: Wha Happen?

that's the only way to do it. Been adding year end stuff across 12 sheets forever. Long formula and easy to screw up.

_________________
Ба́бушка гада́ла, да на́двое сказа́ла—то ли до́ждик, то ли снег, то ли бу́дет, то ли нет.

Top

conns7901

Post subject: Re: Adding data from different tabs in google sheets

Posted: Mon Feb 08, 2021 10:15 pm

Joined: Wed Nov 30, 2005 11:36 pm
Posts: 19608

City of Fools wrote:

that's the only way to do it. Been adding year end stuff across 12 sheets forever. Long formula and easy to screw up.

Yeah Fuck this. I am going back to excel next year when (if??) we have 30 plus games and tournaments.

_________________

Frank Coztansa wrote:

conns7901 wrote:

Not over yet.

Yes it is.

CDOM wrote:

When this is all over, which is not going to be for a while, Trump will be re-elected President.

Top

City of Fools

Post subject: Re: Adding data from different tabs in google sheets

Posted: Tue Feb 09, 2021 12:39 pm

Joined: Thu Jun 26, 2008 8:22 am
Posts: 15198
pizza_Place: Wha Happen?

IScore?

That's the best way to go.

_________________
Ба́бушка гада́ла, да на́двое сказа́ла—то ли до́ждик, то ли снег, то ли бу́дет, то ли нет.

Top

Page 1 of 1

[ 12 posts ]

Adding data from different tabs in google sheets

Who is online