Is "us postal" the only thing in the cell? That is, you don't have something
like "us postal 100.00" in a cell. Gord's formula should work. Change the
A1:A100 to the range of cells that (might) contain "us postal" and change
the B1:B100 to the range of cells that have the postal amounts. Ensure that
calculation mode is set to automatic (Tools menu, Options, Calculation,
Automatic).
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
"cb" wrote in message
...
Thanks- typed in the replacement nothing happens after I hit enter.
"Gord Dibben" wrote:
=SUMIF(A1:A100,"us postal",B1:B100)
Adjust for your actual ranges.
Gord Dibben MS Excel MVP
On Sun, 7 Oct 2007 10:24:00 -0700, cb
wrote:
I have a spreadsheet from Pay pal.
It lists many columns and cells.
For example in one of the rows it lists "us postal" which are postal
fees I
incurred, for debits and names listed beneath them as credits for paid
sales
gross,
I want to add up only the "us postal" fees in total.
How do I do this to separate this out.