First I want to say thank you for all the help everyone is here. Now for my
question. Still helping my husband do his spreadsheet for work with all his
warehouses. This is what I have:
=SUMPRODUCT(--(Beltman!E12:E21=B3),Beltman!A12:A21)

where E12:E21 is for the Material Type
B3 is material type that I want to get a total number on
A12:A21 is how many of that type

Now I can't figure out the other half of this. Most of the material type has
a size of 4x8 but, some have a size of 4x4. The ones that are 4x4, i need to
add and then divide by 2 so it will give me an amount as if it were a 4x8.
But I need a calculation that will give me 1 number to represent a total
number of all. I hope this makes sense. The calculation as I have it, give me
a total number but doesn't cut the 4x4 in half. Basically they can fit 2 of
the 4x4 in a 4x8 slot so they want to know how many 4x8's they have...

Please help and if its confusing, I can try again to explain it.
krista