i having issue excel problem , cannot use vba or add columns. problem goes along format of image. not find on google helped me problem , im sorry if has been asked before.
on separate page in cell need write function check if info 2 = "z" , info4 = "x" , if true need following equation numbers in info1 , info3: info1*(1 - info3) have keep sum of these numbers.
for example want cell formula equal -34 doing following: 3*(1-4)+5*(1-6) = -34 want cell display finished sum
any appreciated, thank you!
you looking mighty powers of sumproduct
=sumproduct((b:b="z")*(d:d="x")*(a:a)*(1-c:c)) the first 2 multipliers make sure evaluate rows having z b , x d. while latter 2 desired function. excel evaluate each row , sum results.
