New to Excel need very simple help, thanks

[DANEMS12]

I'm guessing this is very simple but cant seem to figure it out, I need to total the tonnage of each different type of product and put it in the table to the right.

Can only seem to get it to tally the products , how do i get the sum of each product's individual tonnages? So i get a total tonnage for each product individually.

Thanks a lot.

 

[Toadstool]

Hi DaneMS12,

I'm guessing your count uses a COUNTIF so you use a SUMIFS to total the tonnage. The wrinkle is that your MIXED CONSTRUCTION has a tonnage of "1 LOAD" which won't work as it's interpreted as text so sums to zero.

Book1
	D	E	F	G	H	I	J	K
3	Product	Tonnage				Clean Crush	2	30
4	Type 1	1.5				6f5	0	0
5	SHARP SAND	1				Rec Type 1	5	40.3
6	SHARP SAND	0.5				0.5 Dust	0	0
7	MIXED CONSTRUCTION	1 LOAD				Turfing Soil	0	0
8	CLEAN CRUSH	15				Reject Sand	0	0
9	REC TYPE 1	5				Ballast	1	1
10	REC TYPE 1	1.3				Sharp Sand	4	8.5
11	SHARP SAND	3				Build Sand	1	1
12	REC TYPE 1	15				10mm Shingle	0	0
13	REC TYPE 1	15				20mm Shingle	0	0
14	BALLAST	1				Type 1	1	1.5
15	MIXED CONSTRUCTION	1 LOAD
16	CLEAN CRUSH	15
17	BUILD SAND	1
18	SHARP SAND	4
19	REC TYPE 1	4
Sheet1

Cell Formulas
Range	Formula
J3:J14	J3	=COUNTIF($D$4:$D$999,I3)
K3:K14	K3	=SUMIFS($E$4:$E$999,$D$4:$D$999,I3)