Excel 2007 : Need help maybe vlookup or sumifs?

[srgtennis]

I am trying to get it to when I put in the receiver it will automatically add up how many boxes there are on the fresh plant page. I can do vlookup but if there is more than one then it doesn't add them together for instance rec # 106362 has 2 entries one for 33 and one for 39, I need it to add them together.

Also anyway it can it when I put in the information on the MARCH PAGE then it will automatically transfer the receiver number to the right room( the book1 is for room 20 there will be 10 other rooms, 21, 22, 23, and so on.) Can it take and put that receiver # in the right room and then also add up how many boxes there are depending on what room it goes to.

I probably explained it better in the book1 example.
thanks

[NBVC]

In A5 enter formula:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER and copy down.

Same formula in H5 except change 20 to 21, then confirm with CSE key combo and copy down

In C5 then enter:

=SUMIF(March!$A$3:$A$29,A5,March!$F$3:$F$29)

copied down

same in J5 except A5 is H5...

[srgtennis]

This works great but one more thing.

=SUMIF(March!$A$3:$A$30,A5,March!$F$3:$F$30) this works to get the answer if the number is in column F3:F30, but I need it to cover column c through n, and I tried to this:=SUMIF(March!$A$3:$A$30,A5,March!$c$3:$n$30) but it doesn't work? I need it to add # of boxes transfered no matter which column it is in.

[NBVC]

Try then:

=SUMPRODUCT((March!$A$3:$A$30=A5)*(March!$C$3:$N$30))

[srgtennis]

thanks for the help that works great

[srgtennis]

=VLOOKUP(AE18,'[3-14-2012 Raw Apples.xlsx]Processing'!$A$3:$AD$8000,8,FALSE)) When I put this in the cell and the Receiver number cell is blank it gives me #N/A, how can I make it blank so if there is nothing in the cell then it will not show anything or zero

[NBVC]

wrap it in an IFERROR

e.g.

=IFERROR(VLOOKUP(AE18,'[3-14-2012 Raw Apples.xlsx]Processing'!$A$3:$AD$8000,8,FALSE),"")