Try this:

=SUMIF(E5:E100,"Co.A",D5:D100)

Better to use a cell to hold the criteria:

A1 = Co.A

=SUMIF(E5:E100,A1,D5:D100)

--
Biff
Microsoft Excel MVP


"Riccol" wrote in message
...
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)