User Profile
JorgeElizondom1963
Copper Contributor
Joined Sep 14, 2020
User Widgets
Recent Discussions
How tu use structured reference as criteria in SUMIFS function
Hi all, I have a table (named SalesData) with three columns: Sales Date (as dd/mm/yy), Region and Amount and thousands of entries. I want to build a summary table that has the years as columns (2019,2020, etc) and Regions as rows. For some very specific reasons this cannot be a pivot table. I am trying to use a SUMIFS function with two criteria for each year/Region combination. My question is how to properly use Structered References inside the SUMIFS function. I want something like SalesData[Region]="Northwest" and Year(SalesData[Date])=2019. For the life of me I cant seem to make it work. Please helpSolved8.3KViews0likes5Comments
Recent Blog Articles
No content to show