Is there a capability in Excel that can create a new spreadsheet providing sums across the groupings and rows of a different sheet?

like
Posting as :
works at
You are currently posting as works at

You mean a pivot table?

like

Uh a pivot table?

likesmart

Sumifs?

like

Copilot for Excel, or CHATGPT‼️

like

A pivot table is what you’re looking for. You’ll use the variable you’re summing as the value, and the groupings as rows or columns. Your data must be formatted correctly on the first sheet to make a pivot table. Reach out if you’d like an example.

like

Like a macro?

Combo of Python and an LLM

Related Posts

does anyone have experience exiting after 1 year? any vengeful MD stories? my MD knows a lot of people and i’m scared if i interview or exit to one of these places that he has a connection at he might try to mess with my career...

like

Is it harder to get into business school than business school itself?

like

Recently i joined cgi but the project does not ses much good as per tech stack.Is there anything I can do in this case.I am tagged to this assignment but project has not yet started.Please help me with issues?

Fear I may have lowballed myself in initial discussions with HR and now expecting a formal offer. Honestly think 10k more would be more fair. What’s the best way for me to negotiate this after the formal offer is presented?

like

Does anyone know how to become an independent contractor?

like

What’s the easiest internal initiative to do on the bench?

I need a good reference article for DSO-SAAS specific

like

What kind of companies pay more than $200k base and what practice areas? Remote or Texas. I’m a new attorney between M&A and L&E, but I’m willing to switch practice areas for the best exit options in the future (4-5 yoe).

Been Interested in working at a FAANG for the past 5 years. I am a Certified Scrum Master, Agile Coach, and Product Owner. I never see many roles in those areas at most FAANG companies ?? Can someone help me out ? Is it a different title at those companies and are referrals needed ??

like

What are some realistic exit opportunities? I’ve been doing insurance/damage loss this whole time. Wouldn’t mind doing the same thing either but I just need a pay increase

like

Hi fishes,
Please help me with Natwest relocation thing. I tried to understand through offer letter but it’s not clear to me. How can I claim Goods transfer, and if I am staying at my friend’s place, how can I claim accommodation allowance. Thanks a lot

Hi Fishers,
anyone who can refer me to Altimetrik.
I'm serving notice period looking for job switch.

Thank

Guys, how much hike we can generally expect in Altimetrik.

What is good altimetrik pune or citi pune?
In altimetrik they giving me Western Union project.. any idea about it

Hi all, I am expecting salary discussion call with Siemens Digitals HR. What is the ideal salary that I can ask? As of now, no offers in hand.

SKILLS: Devops + Tools + Python
YOE: 7.9
CCTC: 18.1 LPA

like

Hi, can anyone refer me to Siemens , yoe 3 years,
Req id 298772
Software Engineer Advanced - frontend/ Full stack
Job family : R&D
On notice period, 45 days left

What was % increment in Advanta for for PL 9,8 levels

A lot of people here seem to glamorize MANGA positions - good pay, and good WLB. There has to be a catch, right?

likehelpful

I need a referral for devops engineer role. 3.5 yoe
1 month remaining of notice period.
Location preference is delhi ncr.
Not getting calls these days

like

2nd year SC with consistent 1 or 2 (top) ratings, and 5 yrs experience in digital / CX. I've decided I need a change - what can comp I expect in NYC at other big 4s? Anyone care to refer me? 🙏

like

Additional Posts in Excel Genius

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

Would anyone be willing to teach me vlookup?

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Still don't have xlookup. #fomo

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal