Excel Datalist functions / lookup summary

Giganews Newsgroups
Subject: Excel Datalist functions / lookup summary
Posted by:  marius.coleraiā€¦@lycos.de
Date: 26 May 2006

Dear Excel Users,

My problem is following. I have one table with 2 columns and 30 rows.
In the right column the user can choose in a drop down list 1 of 5
ledgers (Accounting) for each row.  In the left column I have dollar
values.
Now, filling in the rows 1 to 30 the ledgers (right column) chosen will
repeat themselves.
At the bottom I would like to have 5 independent cells showing a the
sum for one of the five accounts.

Example:

ledger number 1

row 1 5$
row 5 10 $
row 15 10 $

The sum cell one should sum all dollar values for ledger number 1 which
has entries in row 1,5 and 15. So the formula needs to go into each of
these rows and selects the left one of the colums in order read out the
dollar values and total them which is here 25$.

Same for ledger number 2 to 5 in different sum cells.

Anyone any idea how this works.

Replies