Posts by: Christopher B
I have
I am using a SUMPRODUCT that is contingent upon 2 criteria: region and product division. Regions are NAM, LATAM, ASPAC, and EMEA. Product divisions are CS, TT, and FL. The criteria are located in a drop down list to limit responses. My model works fine if I select both a region and a division, such... Read More
I am using a SUMPRODUCT that is contingent upon 2 criteria: region and product division. Regions are NAM, LATAM, ASPAC, and EMEA. Product divisions are CS, TT, and FL. The criteria are located in a drop down list to limit responses. My model works fine if I select both a region and a division, such... Read More
Creating a summary page for dozens of tabs
I have 200+ tabs of individual account data. I am working to have a summary tab pull in information from the same cell on every worksheet. Currently, my only solution is to copy/paste the formulas and ctrl+f and replace the tab titles. Is there a way to speed this process up? Or, is there a way to r... Read More
I have 200+ tabs of individual account data. I am working to have a summary tab pull in information from the same cell on every worksheet. Currently, my only solution is to copy/paste the formulas and ctrl+f and replace the tab titles. Is there a way to speed this process up? Or, is there a way to r... Read More
I actually found an easy work around. I created 2 columns of switches based off of the result of the drop downs. If('drop_down_segment'="All Businesses","All Businesses",'segment_from_data') and If('drop_down_region'="Global","Global",'region_from_data'). Based on the result of that switch, I used =... I actually found an easy work around. I created 2 columns of switches based off of the result of the drop downs. If('drop_down_segment'="All Businesses","All Businesses",'segment_from_data') and If('drop_down_region'="Global","Global",'region_from_data'). Based on the result of that switch, I used =SUMPRODUCT(--('criteria_range_segment'='drop_down-segment'),--('criteria_range_region'='drop_down_region',...).
Let me know if you can think of a simpler way of doing the above or if you have further questions on the subject.
Thanks. Read More