Question

33 fraternity members� names are in Column A, their ages are in column B, and their average drink consumptions per night are in Column C. You need to determine how many drinks members 21 or over will consume. What will the formula look like? A) =SUMIF(C2:C35,">21",B2:B35). B) =SUM(C2:C35,">=21",B2:B35). C) =SUMIF(A2:C35,">=21",C2:C35). D) =SUMIF(B2:B35,">=21",C2:C35).

Answer 1

To calculate the total average drink consumption of fraternity members aged 21 or over, the correct Excel formula is =SUMIF(B2:B35,">=21",C2:C35), which is option D.

The correct option is D

Step-by-step explanation:

To determine how many drinks members 21 or over will consume, the correct formula is:

=SUMIF(B2:B35,"25",C2:C35).

This formula uses the SUMIF function in Excel to sum the values in the range C2:C35 (average drink consumptions per night) only if the corresponding values in the range B2:B35 (ages of fraternity members) meet the specified criteria, which is being 21 or over. The correct answer is option D.

The correct option is D