A formula as the sum_range in a SUMIFS function - is it possible???

[s1specken]

It seems like it's impossible, but I could just be missing a nested function somewhere...really I have no clue how to get to what I'm looking for. I'm trying to use a formula that if the row matches a series of criteria, will take the sum of a formula applied to the matching row (the formula includes Bloomberg Data Pull formulas as well).

I've added the formula I tried to create but can't get to work. Let me know if anybody has any ideas!

Thanks in advance!


=SUMIFS('DATA TAB 2'!D:D/BDP('Data Tab 2'!J:J&" Corp","BLOOMBERG_MNEMONIC1")*BDP('Data Tab 2'!J:J&" Corp","BLOOMBERG_MNEMONIC2"),Citeria Range 1, Citeria 1, Criteria Range 2, Criteria 2...etc.

 

[Pup Denab]

HI s1specken
Welcome to the forum, its not very clear, what your expected result is, so may i suggest you try sumif, for 1 row to see if that works, with your criteria, then paste the formula, I'm sure 1 of us can adapt it to cover your whole range after that, or paste a couple of test lines of data on here, so we can see this issue