Hi there,
While I'm quite able to write some decent code in VBA, I do not really know why but I still meet difficulties coding cells formula.
Here is a SUMIF formula I have:
Basically, in table A, I want my formula to sum conditionally amounts in table b based on info retrievable from table A, C or 2 different named areas. This formula works such fine.
I realized however that I made a theoretical mistake and I want to weight the amounts in table b with an another variable in the same table with the same condition.
I think then that I need a sumproduct function but I do not understand how to integrate the different criteria in it. Anyone has an idea how to adapt this formula to a sumproduct ?
While I'm quite able to write some decent code in VBA, I do not really know why but I still meet difficulties coding cells formula.
Here is a SUMIF formula I have:
Excel Formula:
=SUMIFS(INDIRECT("tableA["var" & LEFT(narea1;FIND(" ";narea1) -1) &"]");
tableA[P_ID];IF([@P_ID]="all";"<>";MATCH([@P];tablec[varname];0));
tableA[T_ID];IF([@T_ID]="all";"<>";VLOOKUP([@T_ID];narea2;2));tableA[Y_ID];
IF([@Y_ID]="all";"<>";[@Y_ID]))
Basically, in table A, I want my formula to sum conditionally amounts in table b based on info retrievable from table A, C or 2 different named areas. This formula works such fine.
I realized however that I made a theoretical mistake and I want to weight the amounts in table b with an another variable in the same table with the same condition.
I think then that I need a sumproduct function but I do not understand how to integrate the different criteria in it. Anyone has an idea how to adapt this formula to a sumproduct ?