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
https://stackoverflow.com/questions/210 ... readsheets
| Chicago Fanatics Message Board https://mail.chicagofanatics.com/ |
|
| Adding data from different tabs in google sheets https://mail.chicagofanatics.com/viewtopic.php?f=47&t=124577 |
Page 1 of 1 |
| Author: | conns7901 [ Mon Feb 08, 2021 12:12 am ] |
| Post subject: | Adding data from different tabs in google sheets |
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) |
|
| Author: | blackhawksfan [ Mon Feb 08, 2021 5:38 am ] |
| Post subject: | Re: Adding data from different tabs in google sheets |
Google sheets can't compete with excel. RIP Bill Gates |
|
| Author: | a retard [ Mon Feb 08, 2021 9:15 am ] |
| Post subject: | Re: Adding data from different tabs in google sheets |
Set it up in Excel and then upload it to google. |
|
| Author: | pittmike [ Mon Feb 08, 2021 9:37 am ] |
| Post subject: | Re: Adding data from different tabs in google sheets |
I can't imagine trying to use anything but Excel. |
|
| Author: | Frank Coztansa [ Mon Feb 08, 2021 10:12 am ] |
| Post subject: | Re: Adding data from different tabs in google sheets |
Turn your Google sheets off then on again. |
|
| Author: | conns7901 [ Mon Feb 08, 2021 11:29 am ] |
| Post subject: | Re: Adding data from different tabs in google sheets |
a retard wrote: Set it up in Excel and then upload it to google. I did. Formula doesn't transfer. |
|
| Author: | Douchebag [ Mon Feb 08, 2021 11:29 am ] |
| Post subject: | Re: Adding data from different tabs in google sheets |
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. |
|
| Author: | Frank Coztansa [ Mon Feb 08, 2021 11:34 am ] |
| Post subject: | Re: Adding data from different tabs in google sheets |
Coons Shuld work on HIM SELF and be USing BLUEHOST??????????? |
|
| Author: | a retard [ Mon Feb 08, 2021 1:28 pm ] |
| Post subject: | Re: Adding data from different tabs in google sheets |
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 https://stackoverflow.com/questions/210 ... readsheets |
|
| Author: | City of Fools [ Mon Feb 08, 2021 4:08 pm ] |
| Post subject: | Re: Adding data from different tabs in google sheets |
that's the only way to do it. Been adding year end stuff across 12 sheets forever. Long formula and easy to screw up. |
|
| Author: | conns7901 [ Mon Feb 08, 2021 10:15 pm ] |
| Post subject: | Re: Adding data from different tabs in google sheets |
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. |
|
| Author: | City of Fools [ Tue Feb 09, 2021 12:39 pm ] |
| Post subject: | Re: Adding data from different tabs in google sheets |
IScore? That's the best way to go. |
|
| Page 1 of 1 | All times are UTC - 6 hours [ DST ] |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|