K

#### kristap

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