All Items in an Order with Shipping

[swissters]

Title is probably extremely confusing without context. I'm trying to count the total number of items that are have the shipping option of "Local Portland Pickup". Right now each order (Column A) has shipping shown in only one row (Column O), but I need the sum of all of the items (Column Q) in the orders that will be "Local Portland Pickup". I have tried SUMIFS but can't figure out how to get it to work with this situation.

eg. Order ID's 349, 348, 347 have 6 rows, and are all being shipped via "Local Portland Pickup". I need it to SUM all of the items in Column Q for those orders.

Any insight is appreciated.

 

[CA_Punit]

Can you post a sample in xl2bb??

sample method to calculate posted.

Master.xlsx
	A	B	C	D	E
1	349	Local Portland Pickup			2
2	348				0
3	347	Local Portland Pickup			1
4	349	Local Portland Pickup			2
5	347				1
Sheet1

Cell Formulas
Range	Formula
E1:E5	E1	=SUMPRODUCT(--($A$1:$A$5=A1),--($B$1:$B$5="Local Portland Pickup"),ROW($A$1:$A$5)^0)

 

[CA_Punit]

=SUMPRODUCT(--($A$1:$A$5=A1),--($B$1:$B$5="Local Portland Pickup"))

 

[swissters]

Unfortunately, I'm using Google Sheets so I don't think I can post via XL2BB.

What I'm trying to do is SUM the items in your column E. Column E is not calculated. Basically these are orders that come in, column E is the number of items sold, and I want to figure out how many total items are being shipped via "Local Portland Pickup". Every item in order 347 is "Local Portland Pickup" even though it only shows up in one cell. Here is a broader view of the spreadsheet.

 

[Fluff]

Unfortunately, I'm using Google Sheets so I don't think I can post via XL2BB.

It is always better to mention this in your op. Excel & Google sheets are NOT the same. I have also moved this to the correct forum.

 

[swissters]

Understood. Sorry about that. I have always used excel formulas in my spreadsheets without issue.

If you have any input on this I'd greatly appreciate it!