You have a table containing sales data with columns Reg... | Cyber Class 8

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 A. =SUMIF(A:A,"South",C:C)
B B. =SUMIFS(C:C,A:A,"South",B:B,"Laptop")
C C. =COUNTIFS(A:A,"South",B:B,"Laptop")
D D. =VLOOKUP("Laptop",A:C,3,FALSE)