example: SUMIFS

Owned by K A

Last updated: Feb 07, 2018 by Anonymous

1 min read

	A	B	C	D
1	P	X	1	formula: SUMIFS(C1:C4, A1:A4, "Q", B1:B4, "X")
2	P	Y	2
3	Q	X	3
4	Q	Y	4

	A	B	C	D
1	1	2	1	formula: SUMIFS(C1:C4, A1:A4, ">1", B1:B4, "==2")
2	2	4	2		sum(a1,b2)
3	3	2	3
4	4	4	4