PaulFogel123
Member
Hello,
Another challenge formula! The attached file has two tables. I created a weighted average using the SUMPRODUCT formula with criteria added, like so:
Is there an additional criterion to add to fix this, or is there a better way?
Paul
Another challenge formula! The attached file has two tables. I created a weighted average using the SUMPRODUCT formula with criteria added, like so:
(SUMPRODUCT((Analysis!$K$4:$K$31="Medical")*(Analysis!L$4:L$31)*(Analysis!$C$4:$C$31="Medical")*(Analysis!D$4:D$31)))/L35
It was two tables that I converted to ranges to make it easier to see in this sample. It works great. But here's the problem: These tables must remain separate, and each column is sortable. When the sort order is not the same in each table, the SUMPRODUCT formula doesn't work as intended--it simply multiplies the first instance in one table by the first instance in the other table.Is there an additional criterion to add to fix this, or is there a better way?
Paul