All Count Formula in Excel

 

All Count Formula

Count Formula

Only Count Number Series

=Count(E1:E17)

 

	A	B	C	D	E	F
1	S.no	Item	Compamy	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	8888
6	5	Printer	Canon	11000	6	66000
7	6	Monitor	LG	5400	7	37800
8	7	Printer	Epson	11000	3	222
9	8	Rom	Quantum	1500	2	3000
10	9	CD	Samsung	521	1	521
11	10	Ram	Kingston	950	4	3800
12	11	Rom	Quantum	1500	5	868
13	12	Monitor	LG	5400	7	37800
14	13	Printer	Epson	365	9	3285
15	14	Monitor	LG	5400	3	16200
16	15	Printer	Canon	11000	7	321
17	16	Rom	Quantum	1500	6	9000
14	13	Printer	Epson	365	9	3285
15	14	Monitor	LG	5400	3	16200
16	15	Printer	Canon	11000	7	321
17	16	Rom	Quantum	1500	6	9000
				Count	20

 

Counta Formula

Count Number and Text Cell

=Counta(A2:A9)

 

	A	B
1	Department	No. of Department
2	Human Resource	8
3	Marketing
4	Sales
5	Accounting
6	Marketing
7	Accounting
8	Sales
9	Human Resourse

 

Countblank Formula

Only Count Blank Cell

=Countblank(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	8888
6	5	Printer	Canon	11000	6	66000
7	6	Monitor	LG	5400		37800
8	7	Printer	Epson	11000	3	222
9	8	Rom	Quantum	1500	2	3000
10	9	CD	Samsung	521	1	521
11	10	Ram	Kingston	950		3800
12	11	Rom	Quantum	1500	5	868
13	12	Monitor	LG	5400	7	37800
14	13	Printer	Epson	365		3285
15	14	Monitor	LG	5400	3	16200
16	15	Printer	Canon	11000	7	321
17	16	Rom	Quantum	1500	6	9000
14	13	Printer	Epson	365	9	3285
15	14	Monitor	LG	5400	3	16200
16	15	Printer	Canon	11000	7	321
17	16	Rom	Quantum	1500	6	9000
				Countblank	3

 

Countif Formula

Count two and more then Value

=Countif(E2:E17,”Canon”)

 

	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	8888
6	5	Printer	Canon	11000	6	66000
7	6	Monitor	LG	5400	7	37800
8	7	Printer	Epson	11000	3	222
9	8	Rom	Quantum	1500	2	3000
10	9	CD	Samsung	521	1	521
11	10	Ram	Kingston	950	4	3800
12	11	Rom	Quantum	1500	5	868
13	12	Monitor	LG	5400	7	37800
14	13	Printer	Epson	365	9	3285
15	14	Monitor	LG	5400	3	16200
16	15	Printer	Canon	11000	7	321
17	16	Rom	Quantum	1500	6	9000
14	13	Printer	Epson	365	9	3285
15	14	Monitor	LG	5400	3	16200
16	15	Printer	Canon	11000	7	321
17	16	Rom	Quantum	1500	6	9000
		Countif	3

 

Countif Formula

=Countif(B1:B11,B14)

 

	A	B	C	D
1	Product Name	Region	Seller Name	Qty Sold
2	Printer	East	Ram Traders	23
3	Scanner	West	ABC Ltd	20
4	Monitor	North	Shivam	30
5	Mouse	East	Ram Traders	40
6	Mouse	West	ABC Ltd	34
7	Printer	North	Shivam	54
8	Scanner	East	Ram Traders	30
9	Monitor	West	ABC Ltd	10
10	Mouse	North	Shivam	20
11	Mouse	East	Ram Traders	25
12
13	Product Name	Region	Total Records
14	Mouse	North	3

 

Countifs Formula

=Countifs(A1:A11,A2,B1:B11,B2)

	A	B	C
1	Product Name	Region	Total Records
2	mouse	east	2

	A	B	C	D
1	Product Name	Region	Seller Name	Qty Sold
2	Printer	East	Ram Traders	23
3	Scanner	West	ABC Ltd	20
4	Monitor	North	Shivam	30
5	Mouse	East	Ram Traders	40
6	Mouse	West	ABC Ltd	34
7	Printer	North	Shivam	54
8	Scanner	East	Ram Traders	30
9	Monitor	West	ABC Ltd	10
10	Mouse	North	Shivam	20
11	Mouse	East	Ram Traders	25