Using the table below, we want to calculate the total Sales when the Region is “North” and the Product is “Laptop”. Choose the option that gives the correct formula.

Question

Answer

=SUMIFS(C1:C8, A1:A8, "North", B1:B8, "Laptop")

Answer

=SUMIFS(A1:A8, "North", B1:B8, "Laptop", C1:C8)

Answer

=SUMIF(C1:C8, A1:A8, "North", B1:B8, "Laptop")

Answer

=SUMIFS(C1:C8, A1:A8="North", B1:B8="Laptop")

	A	B	C
1	Region	Product	Sales
2	North	Laptop	450
3	South	Tablet	780
4	North	Tablet	120
5	East	Laptop	550
6	North	Laptop	230
7	South	Laptop	810
8	North	Phone	240

Crowdly

Using the table below, we want to calculate the total Sales when the Region is “...

Want instant access to all verified answers on elearning.aua.am?