Log In
Register
Home
New Member
January 14, 2021
Offline
I need to add all of the raw data into the tab 2021 Tier 2 and have that data sum in the Totals tab for each respective cell. The issue is that I need a formula to extract sum the data that is collected based on certain criteria in the 2021 Tier 2 tab cells that have inputs. Basically, I need the "sum here" cells on the Totals tab to be updated based on the raw data that is collected on the 2021 Tier 2 tab. I have attached the spreadsheet for your review. The data in rows 7-9 is bogus data for visual purposes only. The cells will always be inputted a "1". The cells that are populated in each row are determined by what is inputted by the user data.
I appreciate any feedback on how to do this.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
You will have to reorganize the data.
Are you familiar with power query?
VIP
Trusted Members
December 7, 2016
Offline
Hello,
My advice, and that is what I think Catalin also means, is to put your data in a tabular format, structured in columns. That data is easy to fetch and arrange to your need, either by using Pivot Table or to the summary sheet you show in your sample file. One other benefit of using tabular format is that you can add more columns without breaking any existing formulas (if you have used structured referencing that is).
If you want to learn more in an efficient way I think the Excel Tables course could be a good starting point.
Br,
Anders
1 Guest(s)
