Cyber Class 8 Advanced MS Excel

Asked by PRARTHANA P NAIR · Chinmaya Vidyalaya Thiruvananthapuram South Naruvamoodu

You have a table containing sales data with columns Region, Product, and Sales Amount. You want to calculate the total sales for the product "Laptop" in the "South" region using a single formula. Which formula is correct?

Answer as guest — Start Free Practice Test to earn Practice PointsHow to earn pointsAsk a question+3Answer a question+1Someone answers yours+1Your Q gets upvoted+1Pioneer bonus (first 5)+5, ask questions & climb the leaderboard!

A =SUMIF(A:A,"South",C:C)
B =SUMIFS(C:C,A:A,"South",B:B,"Laptop")
C =COUNTIFS(A:A,"South",B:B,"Laptop")
D =VLOOKUP("Laptop",A:C,3,FALSE)

Show answer and explanation

Answer: B. =SUMIFS(C:C,A:A,"South",B:B,"Laptop")

The SUMIFS function allows multiple criteria:

SUMIFS(Sales Amount, Region=South, Product=Laptop)

C:C → Sales Amount column (values to sum)
A:A,"South" → Region must be South
B:B,"Laptop" → Product must be Laptop

SUMIF supports only one condition, COUNTIFS counts records instead of summing, and VLOOKUP returns a matching value rather than summing multiple records.

Answering after opening this box earns no Practice Points.

2 answered 0% got it right

Rules for asking and answering

You have a table containing sales data with columns Region, Product, and Sales Amount. You want to calculate the total sales for the product "Laptop" in the "South" region using a single formula. Which formula is correct?

More questions like this