Summing values for split groups

[Ross]

I have a spreadsheet consisiting of order numbers, product codes, pallet
types and numbr of pallets.
One order number can relate to several products and each product relates to
one of two pallet types.
I can sort the data firstly by order number and then by pallet type easily
enough, but how can I find out the quantity of each pallet type related to
each order without manually going through and adding them up?

Thanks very much.

 

[Luke M]

Order number in column A, pallet type in column c, quantity in D
=SUMPRODUCT((A2:A100="Order# 1234")*(C2:C100="Wood pallet")*(D2100))

You can follow this general format to add other conditions (say, the product
code). Note that the array lengths cannot be the entie column (unless using
XL 2007) and they must be equal sizes.

 

[Ross]

That's not doing what I'd hoped.
If I give an example would that make it easier to interpret my jibberish?

This is what my spread sheet looks like:

ORDER# PRODUCT PALLETTYPE QTY
123 SHAMPOO 01 7
123 CONDITIONER 01 4
123 SHOWER GEL 03 9
123 SOAP 03 3
124 POT NOODLE 01 6
124 SUPER NOODELS 01 8
124 CUPPA SOUP 03 4
124 BIG SOUP 03 5

From that spreadsheet I want a report that says SOMETHING LIKE

ORDER# PALLETTYPE QTY
123 01 11
123 03 12
124 01 14
124 03 9

That way I know how many of each pallet type were used on each order,
regardless of the product they carried.

Thanks for your efforts though Luke.

Ross.

 

[Ross]

Ah, a pivot table!
Managed to find out on my own, but my pivot table format isn't quite right.
How do I change it's appearance so that it looks more like what I was aiming
for with the order number in every row and no totals rows in between order
numbers?

Cheers.

Ross.