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

Subject: | RE: Excel Datalist functions / lookup summary |

Posted by: | CLR |

Date: | Fri, 26 May 2006 |

Try

=SUMIF(A1:A30,1,B1:B30)

=SUMIF(A1:A30,2,B1:B30)

etc etc

Vaya con Dios,

Chuck, cABGx3

"marius.coleraiā¦@lycos.de" wrote:

> 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.

None

Excel Datalist functions / lookup summary posted by marius.coleraiā¦@lycos.de on 26 May 2006