Related Posts
Associate producer salary at MAL?
More Posts
Team Lead Operations
America is so ugly.
Really sucks how unfair life can be
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
Additional Posts in Excel Genius
New to Fishbowl?
unlock all discussions on Fishbowl.




Your situation isn’t clear to me but sounds like an Offset or Match within the sumif is what you’re looking for?
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?