Loading

How to achieve Excel SUMIFS function with ranges from another sheet

發佈日期: Apr 13, 2024
工作
How to achieve Excel SUMIFS function with ranges from another sheet:

Data:
User-added image

Other Sheet:
User-added image

Function:
=SUMIFS('Other Sheet'!$C$2:$C$13,'Other Sheet'!$A$2:$A$13,A2,'Other Sheet'!$B$2:$B$13,B2)

User-added image

 
步驟
1. Connect to the Excel file and add [Other Sheet] as input.

2. Add Aggregate step as below.
User-added image

3. Add [data] as input and join with Aggregate step above as below.
User-added image

4. Field [SUM_range] is the target field.
User-added image
知識文章編號

001470700

附件

SUMIFS.tflx

12 KB

SUMIFS.xlsx

10 KB

 
正在載入
Salesforce Help | Article