Question
How to achieve Excel SUMIFS function with ranges from another sheet:Data:
Other Sheet:
Function:
=SUMIFS('Other Sheet'!$C$2:$C$13,'Other Sheet'!$A$2:$A$13,A2,'Other Sheet'!$B$2:$B$13,B2)
Last Modified Date: 18 Apr 2023
Data:
Other Sheet:
Function:
=SUMIFS('Other Sheet'!$C$2:$C$13,'Other Sheet'!$A$2:$A$13,A2,'Other Sheet'!$B$2:$B$13,B2)
Environment
- Tableau Prep Builder
- Excel
Answer
1. Connect to the Excel file and add [Other Sheet] as input.2. Add Aggregate step as below.
3. Add [data] as input and join with Aggregate step above as below.
4. Field [SUM_range] is the target field.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials