Counting Multiple, Inconsistent Order Lengths as a Singular Order

[jmackey]

I'm currently trying to sum up the total number of items ordered within a single order. Currently, I have tried to individually go through and find the number of repeated order numbers in order to find how many lines of items I need to sum into a singular order number.

What I would like to do is to use Excel to return the total number of items ordered per order number as a two-column return (input is depicted in link below). How would I go about doing this?

https://ibb.co/dmMG9n

Thanks!

 

[dave2018]

I don't see which cells you intend to put the input in, and besides, do you want a summary of the entire data? Or do you want just the input criteria to pop up?

 

[jtakw]

Hi,

Not sure if you mean this:

Excel 2010
	A	B	C	D	E	F
1	Order Number	Item	Quantity		Order Number	Total Items
2	1	Socks	2		1	9
3	1	Pants	3		2	12
4	1	Shirt	4		3	23
5	2	Socks	5		4	84
6	2	Pants	2		5	20
7	3	Socks	3
8	3	Pants	4
9	3	Shirt	1
10	3	Belt	6
11	4	Socks	72
12	4	Pants	3
13	4	Shirt	1
14	4	Belt	5
15	4	Hat	3
16	5	Socks	20
17	2	Hat	5
18	3	Hat	9
Sheet4

Cell Formulas
Range	Formula
F2	=SUMIF(A$2:A$18,E2,C$2:C$18)

F2 formula copied down.

 

[dave2018]

Right, it isn't so clear from your question...

 

[jmackey]

Exactly what I meant! Sorry my question was so vague.

 

[dave2018]

anyway, glad that you found your solution! feel free to revisit with any more questions.

 

[jtakw]

Exactly what I meant! Sorry my question was so vague.

No problem, glad it was what you needed. Welcome to the forum.