- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- Excel Datalist functions / lookup summary

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.

- RE: Excel Datalist functions / lookup summary posted by CLR on Fri, 26 May 2006
- Re: Excel Datalist functions / lookup summary posted by AndyB on Fri, 26 May 2006