A. =SUM(B2:B4,D2:D4) B. =SUM(B2:D2)*(SUM(B4:D4)) C. =SUMIF(B2: D2)*(SUM(B4:D4)) D. =SUMPRODUCT($B$2:$D$2,$B$4 :$D$4)
A. =SUM (IF(B6>70 ”500”),IF(C6>70,”500”),IF(D6>70,"50 ”)) B. =SUMIF(B6>70,”500"),IF(C6>70 ”50 ”),IF(D6>70,”50 ”) C. =IF(B6>70 ,’500”,IF(C6>70,”500” IF(D6>70,”500”)) ) D. =COUNTIF(B6>70,500” IF(C6>70 500”,IF(D6>70’500”)))