One of the sheets in my ledger workbook is for annual cash receipts.
Column D is for the amount (formatted to number-accounting)and Column E
is for who it's from (formatted to number-text). I've got my cells
elsewhere for month, quarter, & year totals.

The problem is I have to manually, with my adding machine, go thru and
add up the total from each source. (How much total income for the year
is/was from Co.A, Co.B, Co.C, etc..)

I've figured out how to use conditional formatting so that if the text
in Column E cells is say, Co.A, the text will be red, if Co.B, text will
be blue, etc ... Good for visually identifying but I still have to
manually add totals for each company.

Is it possible to make a formula that would go something like "look at
cells E5 thru E100. If a cell contains 'Co.A', then add the value of its
adjacent cell (D - where the number amount actually is) to the total". ??

Sounds far fetched to me, but I figured it's worth asking since I know
Excel can do some really complicated formulas if you know how to create
them.

RC (Excel 2002)