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.