Adding From Specific Named Cells

I have 2 columns named "ASC" and "AE" which have total calculations of stores inventory data. To the right of the "ASC" and "AE" columns are store columns with (C1="store#"), (C2="state"), (C3="name"), and (C4:C14="inventory count") totals.

If at anytime a stores "name"="AE", I want the "inventory count" for that store to calculate within the the "AE" column.

Anytime a stores "name"="anything except AE", I want the "inventory count" for that store to calculate within the the "ASC" column.

A1:A3= "ASC"
A4 through A14= Inventory Total

B1:B3= "AE"
B4 through B14= Inventory Total

C1= Store#
C2= State
C3= Name
C4 through C14= Inventory count

D1= Store#
D2= State...