dynamic sumifs

[daveyc18]

=SUMIFS(Pivot!BQ:BQ,Pivot!AH:AH,K10)

so, column BQ has the header "USD," but the USD column could change when the pivot is refreshed with new data since there would be new currencies added

is there a way to make this dynamic? column AH doesn't need to be dynamic since it's the "row" field

 

[DanteAmor]

Assuming that the first column can be "USD" is the column "BQ" and that the last column can be "CZ"
Adjust the ranges marked in red in the formula

Try:

=SUMIFS(INDEX(Pivot!BQ:CZ,0,MATCH("USD",Pivot!BQ1:CZ1,0)),Pivot!AH:AH,K10)

 

[DanteAmor]

I'm also assuming that the text "USD" is in row 1. If it's in another row, you'll need to change the 1 to your row number:

=SUMIFS(INDEX(Pivot!BQ:CZ,0,MATCH("USD",Pivot!BQ1:CZ1,0)),Pivot!AH:AH,K10)