I am building a query that has 250 columns. 240 of the columns I need to sum, while the others are my grouping variables. When I enter my variables in the cloumns, the total row defaults to the "group by" value. Is there a way I can change the 240 columns to "Sum" at one time, rather than changing thenm one at a time.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Acees Queries
- Thread starter Stag
- Start date
Andrew Fergus
MrExcel MVP
- Joined
- Sep 9, 2004
- Messages
- 5,462
- Office Version
- 365
- 2021
- 2016
- Platform
- Windows
Why are there 240 columns?
Upvote
0
Similar threads
- Question
- Question
