=SUMPRODUCT(--(RIGHT(A2:A20)="1"),(B2:B20+C2:C20))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"addie" wrote in message
...

I have a spreadsheet with several rows of data. Each row's data
corresponds to a code that appears in the 1st field of the row.

Example:

Codes:..............Revenue:......Responses:
AAAAAAA1..........$1,000.........500
BBBBBBBB3.........$2,000.........200
CCCCCCC1.........$3,000.........300
DDDDDDD2.........$4,000.........9000

What formula would enable me to sum up the revenue & responses on rows
that only correspond to codes that end in '1'?

Addie


--
addie
------------------------------------------------------------------------
addie's Profile:
http://www.excelforum.com/member.php...o&userid=25526
View this thread: http://www.excelforum.com/showthread...hreadid=513868