Coded Entries

[Wayne Lewis]

I need the information under Bin Totals : pcs. and lbs. to automatically
tranfer down to the second columns of Total PCS. and TOTAL LBS. depending
on the coded entry under title DESTINATION. HELP!


Bin Totals DESTINATION USE CODE!
pcs lbs
10 500 A1
20 1000 B1
15 750 A1





CODE COMPANY FULL NAME TOTAL PCS. TOTAL LBS.
A1 Alaska Glacier Seafoods, Inc.
B1 Alaska Seafood Co. Inc.
C1 Icy Strait Foods, Inc.
D1 Ocean Foods Industries LTD
E1 The Depot

 

[swatsp0p]

use the SUMIF function, e.g.

=SUMIF(C1:25,"=A1",A1:A25)
will give you the pcs total.

HTH

BRUCE

 

[swatsp0p]

use the SUMIF function, e.g.

=SUMIF(C1:25,"=A1",A1:A25)
will give you the pcs total.

HTH

BRUCE