Total the amount of times you see a word in a column and total numbers from another column that correspond to that column

[rlabonte68]

I will try to explain what i want. In column Q are numbers and in column X are descriptions. I need column X to total the amount of times it sees North Pile 1 and i also need a total from the corresponding numbers in column Q

Example: X2 =North Pile 3 and Q2 has 31.05. just need a total of the amount of times X2 states North Pile 1,2 or 3 and the totals from Q2 that correspond to X2.

wood file.xlsx
	Q	R	S	T	U	V	W	X	Y	Z
2	31.05	LITTLETON - NH	JB GLADSTONE	46651			Burgess	North Pile 3	RFOX	2
3	34.07	FREEDOM - NH	MCLUCAS	101836			Burgess	Chips	RFOX	2
4	33.19	RUMNEY - NH	RCT	79991			Burgess	SP 1	RFOX	2
5	31.42	COLUMBIA - NH	AB TRUCKING	10257	AB FORESTRY		Burgess	North Pile 1	RFOX	2
6	30.53	LITTLETON - NH	RC CROWE	49633			Burgess	Chips	RFOX	NONE
7	36.76	COLUMBIA - NH	HICK'S LOGGING	25692			Burgess	North Pile 1	RFOX	2
8	32.35	NEWBURY - VT	RICHARD RIENDEAU	2301			Burgess	Chips	RFOX	NONE
9	34.12	MADISON - NH	WILLIAM DAY	3320	MILL		Burgess	Chips	RFOX	2
10	34.54	STOW - ME	JOHN KHIEL TRUCKING	38047	545229		Burgess	Chips	RFOX	NONE
11	30.67	E BRIDGEWATER - MA	INGERSON TRUCKING	13925			Burgess	North Pile 1	RFOX	NONE
12	36.35	CHESTERFIELD - NH	HAYNES TRUCKING	58457			Burgess	North Pile 3	RFOX	NONE
13	30.77	LUNENBURG - VT	LARRY BROWN	481			Burgess	Chips	RFOX	2
14	31.12	DERBY - VT	ST ONGE	15900			Burgess	SP 1	RFOX	2
15	31.79	FREEDOM - NH	MCLUCAS	101956			Burgess	Chips	RFOX	NONE
16	28.33	BRENTWOOD - NH	INGERSON TRUCKING	13745	PR RUSSELL		Burgess	SP 3	RFOX	NONE
17	33.19	PIERMONT - NH	WADE REED TRUCKING	9717			Burgess	Chips	RFOX	NONE
18	37.29	BILLERICA - MA	MORANCO TRUCKING	1085			Burgess	North Pile 3	RFOX	2
19	34.87	PASSUMPSIC - VT	B L ROY TRUCKING	121845			Burgess	Chips	RFOX	2
20	34.1	RILEY TOWNSHIP - ME	SL VERRILL TRUCKING	8339	491750		Burgess	Chips	RFOX	NONE
21	29.16	STANDISH - ME	SMT & E TRUCKING	126659	2100071		Burgess	Chips	RFOX	NONE
22	29.91	SANDWICH - NH	WESTERN MAINE TIMBERLANDS	31580	20-407-26-T		Burgess	North Pile 1	RFOX	NONE
23	33.66	BYFIELD - MA	H & S TRUCKING	703633			Burgess	SP 3	RFOX	2
24	30.94	E BRIDGEWATER - MA	INGERSON TRUCKING	11656			Burgess	SP 2	RFOX	NONE
25	29.17	WHITEFIELD - NH	MD TRUCKING	1597			Burgess	SP 2	RFOX	NONE
26	35.66	STOW - ME	JOHN KHIEL TRUCKING	37773	545229		Burgess	Chips	RFOX	NONE
27	35.1	BARTLETT - NH	CALEB CHESSIE EXC	10902	20-029-07-T		Burgess	Chips	RFOX	NONE
28	30.84	STANDISH - ME	WILLIAM DAY	126722	2100071		Burgess	Chips	RFOX	NONE
29	31.57	E BRIDGEWATER - MA	INGERSON TRUCKING	14913			Burgess	SP 2	RFOX	NONE
30	28.64	LUNENBURG - VT	LARRY BROWN	4833			Burgess	Chips	RFOX	NONE
31	33.16	CASCO - ME	C E BOUCHEY	126104	MILL		Burgess	Chips	RFOX	NONE
32	34.78	BALDWIN - ME	RW DAY LOGGING	1442	540580		Burgess	Chips	RFOX	NONE
33	36.88	NEWARK - VT	HB TRUCKING	6493			Burgess	North Pile 1	RFOX	NONE
34	31.85	TAMWORTH - NH	GARLAND LUMBER	118225			Burgess	Chips	RFOX	NONE
35	32.6	CORNISH - ME	STURGEON TRUCKING	98696	528020		Burgess	Chips	RFOX	NONE
36	29.1	LUNENBURG - VT	LARRY BROWN	482			Burgess	Chips	RFOX	NONE
37	29.88	GRAFTON - NH	BLUE CHIP TRUCKING	1562			Burgess	Chips	RFOX	NONE
38	30.62	SANDWICH - NH	WESTERN MAINE TIMBERLANDS	30907	20-407-26-T		Burgess	Chips	RFOX	NONE
39	32.69	WAKEFIELD - NH	LE TAYLOR	47315			Burgess	Chips	RFOX	NONE
40	28.4	WHITEFIELD - NH	MD TRUCKING	1604			Burgess	Chips	RFOX	NONE
41	33.67	BARNSTEAD - NH	WILLIAM DAY	132253	20-025-09-T		Burgess	Chips	RFOX	NONE
42	34.56	JAY - VT	REGINALD RIENDEAU	3895			Burgess	Chips	RFOX	NONE
43	33.41	QUINCY - MA	HAYNES TRUCKING	53694			Burgess	North Pile 1	RFOX	NONE
44	34.43	EFFINGHAM - NH	FADDEN TRUCKING	23641	20-141-20-T		Burgess	Chips	RFOX	NONE
45	32.59	LEBANON - ME	WASHBURNE TRUCKING	169	525757		Burgess	Chips	RFOX	NONE
46	27.42	STRAFFORD - NH	H L R TRUCKING	4642			Burgess	Chips	RFOX	NONE
47	29.32	BEECHER FALLS - VT	RANCOURT TRUCKING	703896			Burgess	SP 1	RFOX	NONE
48	29.4	BURKE - VT	MIKE LEMIEUX TRUCKING	9607			Burgess	Chips	RFOX	NONE
49	32.49	PIERMONT - NH	WADE REED TRUCKING	9894			Burgess	Chips	RFOX	NONE
50	28.65	SANDWICH - NH	WESTERN MAINE TIMBERLANDS	28136	20-407-26-T		Burgess	Chips	RFOX	NONE
51	34.75	ALFRED - ME	JORDAN TREE HARVESTERS	13624	458658		Burgess	Chips	RFOX	NONE
52	30.5	CANAAN - NH	JOSEPH MATTHEW TRKING	630			Burgess	Chips	RFOX	NONE
53	32.24	WASHINGTON - NH	CPA EXPRESS TRUCKING	10119			Burgess	North Pile 1	RFOX	NONE
54	33.83	HENNIKER - NH	RCT	95607			Burgess	SP 1	RFOX	NONE
55	36	EAST HAVEN - VT	NELSON LOGGING & CHIPPING	1773	458204		Burgess	North Pile 1	RFOX	2
56	31.53	LITTLETON - NH	JB GLADSTONE	46645			Burgess	North Pile 1	RFOX	NONE
57	30.08	NEWARK - VT	KML LOGGING & FORESTRY	1555			Burgess	North Pile 1	RFOX	NONE
58	34.09	MADISON - NH	WILLIAM DAY	3322	MILL		Burgess	Chips	RFOX	NONE
59	33.35	ROCHESTER - NH	BRANDON VALLEY TRUCKING	2768			Burgess	Chips	RFOX	NONE
60	37.96	COLUMBIA - NH	HICK'S LOGGING	25693			Burgess	Chips	RFOX	NONE
61	33.33	FREEDOM - NH	MCLUCAS	101837			Burgess	Chips	RFOX	NONE
62	35.05	ISLAND POND - VT	MORRISON TRUCKING	3109			Burgess	Chips	RFOX	NONE
63	35.9	HOLLIS - ME	JORDAN FAMILY TRUCKING	5954	549683		Burgess	Chips	RFOX	NONE
64	33.86	BYFIELD - MA	H & S TRUCKING	703634			Burgess	SP 2	RFOX	NONE
65	34.59	RILEY TOWNSHIP - ME	SL VERRILL TRUCKING	8340	491750		Burgess	Chips	RFOX	NONE
66	29.33	BRIDGEWATER - MA	INGERSON TRUCKING	13867			Burgess	North Pile 1	RFOX	NONE
67	34.86	COLUMBIA - NH	AB TRUCKING	10258			Burgess	Chips	RFOX	NONE
68	24.94	WHITEFIELD - NH	MD TRUCKING	1598			Burgess	Chips	RFOX	NONE
69	34.83	BARTLETT - NH	CALEB CHESSIE EXC	10903	20-029-07-T		Burgess	Chips	RFOX	NONE
70	29.37	BROWNFIELD - ME	WILLIAM DAY	12181	521108		Burgess	North Pile 1	RFOX	NONE
71	31.19	LUNENBURG - VT	LARRY BROWN	4834			Burgess	Chips	RFOX	NONE
72	33.87	PORTLAND - ME	JIM WORDEN LOGGING	3863	545043		Burgess	Chips	RFOX	NONE
73	32.21	NEWBURY - VT	RICHARD RIENDEAU	2302			Burgess	Chips	RFOX	NONE
74	30.99	DERBY - VT	ST ONGE	15380			Burgess	SP 2	RFOX	NONE
75	33.43	NEWARK - VT	RC LOCKE TRUCKING	6836			Burgess	Chips	RFOX	NONE
76	27.47	WHITEFIELD - NH	MD TRUCKING	1605			Burgess	Chips	RFOX	NONE
77	31.61	PIERMONT - NH	WADE REED TRUCKING	9718			Burgess	Chips	RFOX	NONE
78	30.9	BRENTWOOD - NH	C E BOUCHEY	6105123			Burgess	SP 3	RFOX	NONE
79	33.15	STANDISH - ME	SMT & E TRUCKING	126660	2100071		Burgess	Chips	RFOX	NONE
80	31.7	LITTLETON - NH	RC CROWE	49634			Burgess	Chips	RFOX	NONE
81	34.35	SUTTON - VT	RUSSELL RIENDEAU	5140			Burgess	Chips	RFOX	NONE
82	27.79	LUNENBURG - VT	LARRY BROWN	483			Burgess	Chips	RFOX	NONE
83	33.27	STANDISH - ME	WILLIAM DAY	126723	2100071		Burgess	Chips	RFOX	NONE
84	34.16	NORTH BERWICK - ME	MIDBOOST LLC	37753	543158		Burgess	Chips	RFOX	NONE
85	32.99	CORNISH - ME	MCLUCAS	98875	528020		Burgess	North Pile 1	RFOX	NONE
86	30.37	SANDWICH - NH	WESTERN MAINE TIMBERLANDS	31581	20-407-26-T		Burgess	North Pile 1	RFOX	NONE
87	28.87	NEWARK - VT	ACKLIN HUMPHREY	752			Burgess	Chips	RFOX	NONE
88	32.14	LOUDON - NH	J LANDRY & SON	10348			Burgess	Chips	RFOX	NONE
89	35.37	OXFORD - ME	MCLUCAS	101807	548488		Burgess	Chips	RFOX	NONE
90	34.25	RILEY TOWNSHIP - ME	SL VERRILL TRUCKING	8341	491750		Burgess	Chips	TPLANTE	NONE
91	29.22	COLUMBIA - NH	AB TRUCKING	10259	AB FORESTRY		Burgess	North Pile 1	TPLANTE	NONE
92	27.34	WHITEFIELD - NH	MD TRUCKING	1599			Burgess	Chips	TPLANTE	NONE
93	33.57	STOUGHTON - MA	MAC TRUCKING	53757			Burgess	SP 2	TPLANTE	NONE
94	31.13	DERBY - VT	ST ONGE	16032			Burgess	North Pile 1	TPLANTE	NONE
95	35.9	ROME - ME	BROWN & BROWN	16542	542626		Burgess	Chips	TPLANTE	NONE
96	36.3	NEWARK - VT	HB TRUCKING	6494			Burgess	SP 2	TPLANTE	NONE
97	33.6	SHEFFIELD - VT	P & L RIENDEAU	1905			Burgess	Chips	TPLANTE	NONE
98	33.84	WAKEFIELD - NH	LE TAYLOR	47316			Burgess	SP 2	TPLANTE	NONE
99	29.17	LITTLETON - NH	JB GLADSTONE	49693			Burgess	North Pile 1	TPLANTE	NONE
100	37.57	COLUMBIA - NH	HICK'S LOGGING	25694			Burgess	Chips	TPLANTE	NONE
101	30.79	EFFINGHAM - NH	FADDEN TRUCKING	23644	20-141-20-T		Burgess	North Pile 1	TPLANTE	NONE
102	32.81	TAMWORTH - NH	MARSHALL LOGGING	1075	20-443-29-T		Burgess	Chips	TPLANTE	NONE
103	33.1	FREEDOM - NH	MCLUCAS	101838			Burgess	Chips	TPLANTE	NONE
104	31.1	SANDWICH - NH	WESTERN MAINE TIMBERLANDS	30908	20-407-26-T		Burgess	North Pile 1	TPLANTE	NONE
105	33.98	EFFINGHAM - NH	FADDEN TRUCKING	23643	20-141-20-T		Burgess	Chips	TPLANTE	NONE
106	29.67	BEECHER FALLS - VT	RANCOURT TRUCKING	703897			Burgess	SP 1	TPLANTE	NONE
107	32.76	ELMORE - VT	ST ONGE	15925			Burgess	Chips	TPLANTE	NONE
108	31.51	PIERMONT - NH	WADE REED TRUCKING	9895			Burgess	Chips	TPLANTE	NONE
109	32.7	BARNSTEAD - NH	WILLIAM DAY	132254	20-025-09-T		Burgess	Chips	TPLANTE	NONE
110	32.17	SANDWICH - NH	WESTERN MAINE TIMBERLANDS	28137	20-407-26-T		Burgess	Chips	TPLANTE	NONE
111	32.65	PIERMONT - NH	WADE REED TRUCKING	9923			Burgess	Chips	TPLANTE	NONE
112	32.42	BURKE - VT	MIKE LEMIEUX TRUCKING	9608			Burgess	Chips	TPLANTE	NONE
113	34.64	MONROE - NH	RC CROWE	49579			Burgess	SP 2	TPLANTE	NONE
114	36.1	HENNIKER - NH	RCT	95611			Burgess	SP 1	TPLANTE	NONE
115	30.05	GRAFTON - NH	BLUE CHIP TRUCKING	1567			Burgess	Chips	TPLANTE	NONE
116	31.52	EAST HAVEN - VT	NELSON LOGGING & CHIPPING	1774	458204		Burgess	North Pile 1	TPLANTE	NONE
117	30.57	LITTLETON - NH	RC CROWE	49635			Burgess	SP 2	TPLANTE	NONE
118	28.89	MARSHFIELD - MA	JML TRUCKING	107933			Burgess	SP 2	TPLANTE	NONE
119	36.82	MASHPEE - MA	GOVONI FORESTRY	5987			Burgess	Chips	TPLANTE	NONE
120
121
122			Total Trucks		North Pile 1		North Pile 2		North Pile 3
123					xxxx		xxxxx		xxxxx
124
125			Total Tons		North Pile 1		North Pil 2		North Pile 3
126					xxxx		xxxx		xxxx
Fuel Loads

 

[Eric W]

Try:

Book1 (version 2).xlsb
	S	T	U	V	W	X	Y
122	Total Trucks		North Pile 1		North Pile 2		North Pile 3
123			20		0		3
124
125	Total Tons		North Pile 1		North Pil 2		North Pile 3
126			633.89		0		104.69
Sheet16

Cell Formulas
Range	Formula
U123,Y123,W123	U123	=COUNTIF($X$2:$X$119,U122)
U126,Y126,W126	U126	=SUMIF($X$2:$X$119,U125,$Q$2:$Q$119)

 

[rlabonte68]

Eric,

Just what I wanted, thank yo for the quick response. Very much appreciated.
Bob