How do I perform the following in excel Select cell C26 Click the Math Trig button Formulas tab, Function Library group and select SUMIF Click the Range box and select cells B7 B18 This range will be matched against the criteria Press F4 (FN F4) to make the reference absolute Click the Criteria box and select cell B26 Press F4 (FN F4) three times to make the mixed reference $B26 Click the Sum range box, select cells D7 D18 Press F4 (FN F4) to make the reference absolute Click OK Total number of students for the biology department is 37

Question

How do I perform the following in excel  Select cell C26  Click the Math   Trig button  Formulas tab, Function Library group  and select SUMIF  Click the Range box and select cells B7 B18  This range will be matched against the criteria  Press F4 (FN F4) to make the reference absolute  Click the Criteria box and select cell B26  Press F4 (FN F4) three times to make the mixed reference $B26  Click the Sum range box, select cells D7 D18  Press F4 (FN F4) to make the reference absolute  Click OK  Total number of students for the biology department is 37

SolutionInn · Accepted Answer

The Answer is in the image, click to view ...

Question: How do I perform the following in excel: Select cell C26. Click the Math & Trig button [Formulas tab, Function Library group] and select SUMIF.

Step by Step Solution