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)+51 point = ₹1 discount on purchases, 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)

Submit Answer