Q. Which Excel function calculates the total of a range based on a condition?

A
SUM()
B
SUMIF()
C
COUNTIF()
D
AVERAGE()
Solution:

SUMIF() adds up values in a range that meet a specified condition.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!