Formula currently is something like:
Sumproduct(b1:b100,c1:c100) to get the aggregate of (b1*c1)+(b2+c2)+.....etc
How can I add a condition to only perform include in formula if D = something.
So needing a simplified version of the following longhand formula:
if(D1 = a35,b1*c1,0)+if(D2=a35,b2*c2,0)+...etc...all the way through the end of the range. say row 100.
Any ideas?
Thanks!
Sumproduct(b1:b100,c1:c100) to get the aggregate of (b1*c1)+(b2+c2)+.....etc
How can I add a condition to only perform include in formula if D = something.
So needing a simplified version of the following longhand formula:
if(D1 = a35,b1*c1,0)+if(D2=a35,b2*c2,0)+...etc...all the way through the end of the range. say row 100.
Any ideas?
Thanks!