All Sum Formula in Excel

 

All Sum Formula

Sum Formula

=Sum(E2:E17)

	A	B	C	D	E	F
1	S.no	Item	Company	Rate	Qty.	Total
2	1	CD	Samsung	25	2	50
3	2	Ram	Kingston	950	3	2850
4	3	Rom	Quantum	1500	4	6000
5	4	Monitor	LG	5400	5	27000
6	5	Printer	Cannon	11000	6	66000
7	6	Monitor	LG	5400	4	21600
8	7	Printer	Cannon	11000	3	33000
9	8	Rom	Quantum	1500	2	3000
10	9	CD	Samsung	25	1	25
11	10	Ram	Kingston	950	4	3800
12	11	Rom	Quantum	1500	5	7500
13	12	Monitor	LG	5400	7	37800
14	13	Printer	Cannon	11000	8	88000
15	14	Monitor	LG	5400	3	16200
16	15	Printer	Cannon	11000	7	77000
17	16	Rom	Quantum	1500	6	9000
		Total			70

 

Sumif Formula

=Sumif(B2:B17,G2,F2:F17)

 

	A	B	C	D	E	F	G	H
1	S.no	Item	Company	Rate	Qty.	Total	Item	Total
2	1	CD	Samsung	25	2	50	Monitor	102600
3	2	Ram	Kingston	950	3	2850
4	3	Rom	Quantum	1500	4	6000
5	4	Monitor	LG	5400	5	27000
6	5	Printer	Cannon	11000	6	66000
7	6	Monitor	LG	5400	4	21600
8	7	Printer	Cannon	11000	3	33000
9	8	Rom	Quantum	1500	2	3000
10	9	CD	Samsung	25	1	25
11	10	Ram	Kingston	950	4	3800
12	11	Rom	Quantum	1500	5	7500
13	12	Monitor	LG	5400	7	37800
14	13	Printer	Cannon	11000	8	88000
15	14	Monitor	LG	5400	3	16200
16	15	Printer	Cannon	11000	7	77000
17	16	Rom	Quantum	1500	6	9000

 

 

Sumifs Formula

 

=Sumifs(F2:F17,C2:C17,H2,B2:B17,G2)

	A	B	C	D	E	F	G	H	I
1	S.no	Item	Company	Rate	Qty.	Total	Item	Company	Total
2	1	CD	Samsung	25	2	50	Printer	Epson	121000
3	2	Ram	Kingston	950	3	2850
4	3	Rom	Quantum	1500	4	6000
5	4	Monitor	LG	5400	5	27000
6	5	Printer	Cannon	11000	6	66000
7	6	Monitor	LG	5400	4	21600
8	7	Printer	Epson	11000	3	33000
9	8	Rom	Quantum	1500	2	3000
10	9	CD	Samsung	25	1	25
11	10	Ram	Kingston	950	4	3800
12	11	Rom	Quantum	1500	5	7500
13	12	Monitor	LG	5400	7	37800
14	13	Printer	Epson	11000	8	88000
15	14	Monitor	LG	5400	3	16200
16	15	Printer	Cannon	11000	7	77000
17	16	Rom	Quantum	1500	6	9000

 

Sumproduct Formula

=Sumproduct(D2:17,E2:E17)

	A	B	C	D	E	F
1	S.no	Item	Company	Rate	Qty.	Total
2	1	CD	Samsung	25	2	50
3	2	Ram	Kingston	950	3	2850
4	3	Rom	Quantum	1500	4	6000
5	4	Monitor	LG	5400	5	27000
6	5	Printer	Cannon	11000	6	66000
7	6	Monitor	LG	5400	4	21600
8	7	Printer	Epson	11000	3	33000
9	8	Rom	Quantum	1500	2	3000
10	9	CD	Samsung	25	1	25
11	10	Ram	Kingston	950	4	3800
12	11	Rom	Quantam	1500	5	7500
13	12	Monitor	LG	5400	7	37800
14	13	Printer	Epson	11000	8	88000
15	14	Monitor	LG	5400	3	16200
16	15	Printer	Cannon	11000	7	77000
17	16	Rom	Quantum	1500	6	9000
				Total		398825

 

Sumsq Formula

=Sumsq(A1,B1)

=Sumsq(A1,B1,C1)

=Sumsq(A1,B1,C1)

 

	A	B	C	D
1	3	4		25
2	3	5	2	34
3	4	5	6	77
4

 

SUMX2MY2 Formula

(A²-B²)=(A+B)*(A-B)

=SUMX2MY2(A1,B1)

	A	B	C
1	5	3	16
2	6	4	20
3	7	5	24
4

 

SUMX2PY2 Formula

(A²+B²)=(A+B)²-2AB

=SUMX2PY2(A1,B1)

 

	A	B	C
1	5	3	34
2	6	4	52
3	7	5	74
4

 

SUMXMY2 Formula

(A-B)²=A²+B²-2AB

=SUMXMY2(A1,B1)

 

	A	B	C
1	5	3	4
2	6	4	4
3	7	5	4
4