Loading

How to achieve Excel SUMIFS function with ranges from another sheet

Data pubblicazione: Apr 13, 2024
Operazione
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

 
Fasi
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
Numero articolo Knowledge

001470700

Allegati

SUMIFS.tflx

12 KB

SUMIFS.xlsx

10 KB

 
Caricamento
Salesforce Help | Article