How can I update the range in one location for a tab whose data source, a second tab, is connected to SAP and the range updates on the source tab depending on quarterly activity?

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

Your situation isn’t clear to me but sounds like an Offset or Match within the sumif is what you’re looking for?

like

Ah, if it’s just the length of the range then try dynamic named ranges (you use an offset formula when defining the range name). Exceljet has an article just search “dynamic range with offset”. Good luck

I’m trying to avoid having to manually update the range in each column as each one had a complete sum if formula that is different in each column. The only common thing is the range it’s searching in the SAP source data. Is there a one place fix for this?

Related Posts

How much should a senior manager specializing in State and Local Tax working at a top 10 PA firm with 15 years of experience be making? Any thoughts?

like

What should be an average salary for an AVP of 6 years experience with Credit suisse Poland #wroclaw

I have done with all rounds of Nagarro and Sapient. What should my exp CTC for Technical Manager profile. Nagarro @sapient YoE -14.5 CCTC - 26.7

like

How much do bcom grads earn for associate 1 level? In AC, Advisory? (Salary range)

like

NeedMore$:
I started QA at the company I am currently at 3 years ago. Long story short, within 4 months at the company, I was able to make a career change and step into a PM position. Without having the formal education or PM experience, only my 5 years in QA experience. When I started I made $65k and have jumped to $78k. I have seen other companies post $100k+. Annual review is tomorrow. Should I fight for more or look for more somewhere else if I lose that fight?

like

Associate producer salary at MAL?

like

How much is the shift allowance for US or UK shift????

I am ready to transition my Salesmen to a base salary with commission to incentivize new hires & reward my long term guys. My industry is aftermarket auto parts. I am leaning towards a 2% commission but am flexible and just need help in figuring out salaries.

Hello fishes,
Can anyone tell me what will be my in-hand salary?
Thanks in advance

Post Photo
like

Any insights on the London Big 4 bonus range for SM (tax)?

like

Hi All. Does anyone know the salary range for a senior control management specialist at Wells Fargo. 6yoe . Skills - Tableau, python, Sas.

like

What salary expectations should I put in front of Bank of America

4.8 years experience
Big data engineer profile Bank of America

like

I'm currently Working at ntt data business solutions. I'm quite underpaid with about 57k goal salary. - 52k fix and 5k Bonus. With 3years expierence in sap consulting mm/ sd 5 years as a key User in a DAX Company and a M.Sc. in IT Mamagement.
I'm thining about apply for a job at the SAP directly or going into a supply chain role.
My goal is a good work life Balance, traveling at least 1 time a Month international and a salary of about 85k.
Any Suggestion?

like
like

Current a commercial banking II analyst at truist, $95k total comp. Looking at switching into tech sales, got an interview for an account executive position in fintech. Anyone know comps for Florida or recommend the move? Heard WLB and perks are great.

like

Are there any additional deductions from the first salary of new hires?

like

hello! I’m looking to get some insight to see if I’m being paid fairly for where I’m at in my career. I’ve worked at the same company for 2.5 years. This is my first job out of college. Started as an HR Admin, basically in a call center for all HR related inquiries and now am a Sr Admin assisting with escalations, interviewing, training new hires, supporting my team, scheduling, keeping track of stats- phone calls, tickets resolved, etc. I’m making $52k per year and work remote out of MA.

like

Hi fishes, How much(max) joining bonus or retention bonus we can expect from Vodafone(_Vois)? Anyone who joined please help me so that I can discuss with recruiter.
Vodafone IBM Tata Consultancy Cognizant Infosys

like

Any want want to move to the Bay Area for a Media Comms role? 2-4 yrs exp. $75k. Plus relo. Healthcare brand . (Not pharma). Lovely warm agency. Honest

like

EY TARAS or EY GCR??? Between these 2 service lines which has better pay and opportunities??

like

More Posts

I’m in the process of renegotiating my contract at my current company; small agency/production house, what is a typical creative producer making in LA? I can provide more detail if that helps!! Thanks

Who wants to link up this weekend, drinks on me. I’m M 🐠 btw

likehelpful

I’m curious if anyone knows of any NY or NYC laws around requirements for an employer to employ a certain percentage of underrepresented minority groups? Would greatly appreciate any guidance here!

like

First time poster here!

After spending 4 years as a mid-level ops manager, I tried to break into HR through talent acquisition. Now after 6 years in TA, I've had a hard time getting out of it. My goal was always to get into a more broad HRBP position, but I've since worked for smaller orgs without a solid HR career path. When I ask about my career goals, they keep telling me, "Soon!" Or "Maybe in 6 months!"

I'm testing SPHR in June. Any advice for securing the type of role I'm aiming for?

like

Pretty sure the saga of the slave driven company has come to an end I’m the only HR person at this company. Friday I had full admin rights, and went to check email Saturday; account locked. Payroll/HRIS locked out. PEO service says no pending termination is on my file. Went to the office today to get my things just in case. Located in CA. Was about to report numerous violations too. All because I couldn’t solve 8 months of payroll issues in a day. 🫠 Good riddance, I’m getting a lawyer.

like

Has anyone been to Helen, GA? Is it worth a weekend getaway?

Looking to upgrade the dress shirt game… bought my first brooks brothers shirt but want to see what else is out there as I don’t love the fit. Best advice?

likefunny

Team Lead Operations

like

Hello fishes,
Anyone has a clue when will Form-16 be available?
My LWD is near, so just wanted all these docs before I loose access.

like

America is so ugly.

likesmartfunny

Really sucks how unfair life can be

like

Ericsson IT Solutions & Services Hi folks I have been selected in below companies. Working as a Java backend developer in TCS with 3.5 years of experience. To day is my last working day. Please suggest me in choosing company

Accenture Bangalore
ADP(Automatic Data Processing) Hyderabad Ericsson IT Solutions & Services Bangalore Virtusa (Standard Chartered Bank client project)
ACS Solutions hyderabad

like

I am looking into a Product Manager role at M&T Bank. Does anyone know the salary range or can tell me about the work/life balance?

like

Hey Fishes !

Temporary accommodation in west Drayton vs Brentford (along A4 highway)?

Any thing to be warned about while making a choice ?

like

I’m a senior in FAAS, did audit first at another firm. Came so close to cpa several times, but work took over and I lost credit to literally all of my exams twice. I’m over it, and I honestly don’t...

like

So what is this rumor about EY switching to biannual promotions and raises for assurance? Any validity to it?

like

How much more does advisory make over the SDC at the same level? I’m a senior 2 in the southeast and make 73....

like

Hi,

Which is better
CitiusTech or Deloitte . Salary is not a concern wlb and projects are important. 5 yoe.

like

Hi Everyone

Need 11 likes to enable DM,

Appreciate your help in advance.

like

Thinking about switching to IFS. Currently in consulting. What’s your WLB?

like

Additional Posts in Excel Genius

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

likehelpful

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Dear auditors, please explain how you pick samples for substantative testing.

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

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.

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

like

Building an invoicing template for a construction comp but won’t be industry specific. I’ll be charging 5 hours at US$80/hr. Anyone want a copy of it for US$40 worth of crypto?

Context:
I spent 2 days last week and tmr fumbling over invoicing activity with the owner using a poorly designed invoicing spreadsheet. Last minute changes to already approved templates impacting >30 invoices is ridiculous. There will be a control sheet, an invoice generating sheet and a summary sheet. Q’s or comments?

like

Is there a way to do a multilevel sort but keep certain rows from sorting? I’ve got a fairly involved project plan with different levels and I need to sort by the dates on certain rows but keep other rows intact

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

My job often has me conducting analyses where we try to identify if product launch A has had an impact on B (cannibalization analyses) but super often they are inconclusive. I feel I need statistics / rudimentary data science here. Any idea what to study?

like

What are some of the unique use cases you have leveraged excel for?

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

like

Presenting data in 2 tables that refer to the same pivot table as source. However, one requires a filter on the pivot table and when filter undone, values change back to original. How to tackle this?

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

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