Pivot Table Help

[whynot]

I created a pivot table from the data listed below in a spreadsheet. Is there a formula or method in a pivot table that would allow me to COUNT the number of rows that does not have a code in column labeled Code and a zero value in column labeled Amount. I highlighted the rows in yellow that meet the criteria. Thank you very much for the help.

 

[etaf]

why a pivot table ?
are you already producing a Pivot table , and is this an additional line

a countifs() would do on its own

Countifs( range with the code , "" , range with the amount , 0 )

if you could use XL2bb - see menu or my signiture to post a sample OR share from somewhere like onedrive/dropbox/google spreadsheet

TECH GUY - CONCATENATE TICKETS IN QUERY.xlsx
	C	D	E	F	G
1	code	amount
2		1		Countifs	2
3		2
4		3
5		4
6
7	a	0
8		0
9		0
Sheet1

Cell Formulas
Range	Formula
G2	G2	=COUNTIFS(C2:C9,"",D2:D9,0)

 

[whynot]

I will install and use XL2bb. I am using a Pivot table to extract other data; therefore, i wanted to figure out a way to find a solution in the pivot table.

 

[whynot]

FDIC 2020 Data 1.0.xlsx
	D	E	F	G	H	I	J	K	L	M	N
1	UNINUMBR	NAMEFULL	ADDRESBR	CITYBR	CNTYNAMB	STALPBR	ZIPBR	Code	CONSOLD	BRSERTYP	Amount
2	6	State Street Bank and Trust Company	1 Lincoln St, Fl 1	Boston	Suffolk	MA	2111	M		11	176,455,000
3	627595	State Street Bank and Trust Company	525 Washington Boulevard	Jersey City	Hudson	NJ	7310	N		11	0
4	614738	State Street Bank and Trust Company	801 Pennsylvania Avenue	Kansas City	Jackson	MO	64105	N		11	0
5	531906	Auburnbank	132 Fob James Drive	Valley	Chambers	AL	36854			11	55,590
6	17	Auburnbank	132 N Gay St	Auburn	Lee	AL	36830	M		11	501,511
7	361391	Auburnbank	1351 S. Donahue Drive	Auburn	Lee	AL	36830			11	32,698
8	478897	Auburnbank	1851 Frederick Road	Opelika	Lee	AL	36801			11	37,018
9	180886	Auburnbank	215 South 6th Street	Opelika	Lee	AL	36801			11	125,204
10	493224	Auburnbank	2315 Bentcreek Road	Auburn	Lee	AL	36830			11	87,432
11	180885	Auburnbank	819 East Glenn Ave Suite 110	Auburn	Lee	AL	36830			12	69,163
12	364622	Auburnbank	950 Auburn Rd.	Notasulga	Macon	AL	36866			11	18,408
13	483412	Robertson Banking Company	1400 Greensboro Avenue	Tuscaloosa	Tuscaloosa	AL	35401			11	48,960
14	180895	Robertson Banking Company	1406 Highway 80 West	Demopolis	Marengo	AL	36732			11	36,510
15	598291	Robertson Banking Company	1801 5th Avenue North, Suite 100	Birmingham	Jefferson	AL	35203			11	21,371
16	530311	Robertson Banking Company	1835 Mcfarland Blvd N	Tuscaloosa	Tuscaloosa	AL	35406			11	22,601
17	229637	Robertson Banking Company	209 East Coats Avenue	Linden	Marengo	AL	36748			11	16,191
18	21	Robertson Banking Company	216 North Walnut Avenue	Demopolis	Marengo	AL	36732	M		11	191,651
19	8456	Robertson Banking Company	6510 2nd Avenue	Thomaston	Marengo	AL	36783			11	11,022
20	180898	Phenix-Girard Bank	1803 Stadium Drive	Phenix City	Russell	AL	36867			11	13,518
21	419878	Phenix-Girard Bank	2481 Lee Road 430	Smiths	Lee	AL	36877			11	8,317
22	180899	Phenix-Girard Bank	3650 Us 280	Phenix City	Russell	AL	36867			11	21,155
23	23	Phenix-Girard Bank	801 13th Street	Phenix City	Russell	AL	36867	M		11	181,806
24	474393	Merchants Bank of Alabama	1096 North Brindlee Mountain Parkway	Arab	Marshall	AL	35016			11	27,383
25	180906	Merchants Bank of Alabama	44 Butler Street	Cullman	Cullman	AL	35058			11	19,325
26	180905	Merchants Bank of Alabama	4855 Highway 157, Northwest	Cullman	Cullman	AL	35055			11	34,396
27	27	Merchants Bank of Alabama	900 Second Avenue, Sw	Cullman	Cullman	AL	35055	M		11	225,479
28	451400	Merchants Bank of Alabama	906 Main Street, Ne	Hanceville	Cullman	AL	35077			11	44,621
29	30	Bank of Evergreen	146 West Front Street	Evergreen	Conecuh	AL	36401	M		11	62,824
30	472658	Community Spirit Bank	1007 4th Street Nw	Red Bay	Franklin	AL	35582	C	0	11	0
31	180919	Community Spirit Bank	14009 Highway 43	Russellville	Franklin	AL	35653			11	31,829
32	31	Community Spirit Bank	200 4th Avenue Sw	Red Bay	Franklin	AL	35582	M		11	86,405
33	61980	Community Spirit Bank	342 Second Street	Belmont	Tishomingo	MS	38827			11	31,235
34	180916	Community Spirit Bank	7141 Highway 19	Vina	Franklin	AL	35593			11	4,137
35	619616	The Bank of Vernon	3561 Bluecutt Road	Columbus	Lowndes	MS	39705	E		11	32,933
36	32	The Bank of Vernon	44825 Highway 17	Vernon	Lamar	AL	35592	M,E		11	108,158
37	180920	The Bank of Vernon	9435 Highway 18	Vernon	Lamar	AL	35592	E		23	27,771
38	587755	The Bank of Vernon	9715 Wolfe Road	Caledonia	Lowndes	MS	39740	E		11	22,930
39	33	The Citizens Bank of Winfield	236 Bankhead Highway	Winfield	Marion	AL	35594	M		11	175,146
40	180927	The Exchange Bank of Alabama	1321a Noccalula Road	Gadsden	Etowah	AL	35904			11	25,631
41	180892	The Exchange Bank of Alabama	230 N 3rd St	Gadsden	Etowah	AL	35901			11	118,384
42	180893	The Exchange Bank of Alabama	3003 Rainbow Dr	Rainbow City	Etowah	AL	35906			11	74,724
43	35	The Exchange Bank of Alabama	7170 6th Ave	Altoona	Etowah	AL	35952	M		11	31,203
44	20	The Exchange Bank of Alabama	923 Cleveland Ave	Attalla	Etowah	AL	35954			11	61,111
45	478542	United Bank	1059 W Loxley Ave	Loxley	Baldwin	AL	36551			11	29,326
2021

Pivot Table

FDIC 2020 Data 1.0.xlsx
	A	B
2	2021
3	Row Labels	Count of BRSERTYP
4	11	75,495
5	C	338
6	E	2,303
7	M	4,474
8	M,C	12
9	M,E	400
10	(blank)	67,968
11	12	3,326
12	C	16
13	E	264
14	(blank)	3,046
15	Grand Total	78,821
Pivot Tables