Excel 2007 : Calculation of multiple cells dependant on data

[DavoP]

Hi peoples

I require a little help solving a calculation of a few cells dependent on what is written in the adjoining cell:=

Example :- See Attached

Weekly Loading Allocation.xlsx

Cells I3 - I19 contain carton quantities, which changes each and every week, the column (J) beside defines destinations.

Off to the right hand side of the work area there are a list of destinations: P7 thru to T7 is where I want to calculate from the I3 - I19 dependent on where items are going.

For Example if I3 has 1452 items going to Pth and I4 has 2040 items going to Bris then I want that to reflect in the appropriate cells P7 - T7

Column "I" might have different destinations anywhere within that column. I want a formula that will pick up and sort out either Pth Bris (multiple times) ETC and add up all the Pth's Bris's in that column.

Hope this makes sense

Cheers PPl

[dilipandey]

Hi DavoP,

welcome to the forum.

Suggest you to correct the thread title of your post to reflect the query you are asking.. see forum rules:-


http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

[Cutter]

Hello DavoP, and welcome to the forum.

In P7 (and dragged across):

=SUMIF($J$3:$J$19,P6,$I$3:$I$19)

[DavoP]

Hi Cutter, thanks heaps for your help, greatly appreciated

[Cutter]

You're welcome. Thanks for the feedback.

[DavoP]

Hi Cutter

I just realized that the bottom cells, under the "b-doubles" heading, is not included in this calculation. How could I add this into that formula. Again I thank you in advance

EDIT:-

I just figured it out.

Cheers