Adding in Excel
 

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.

Adding in Excel
 

=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.

Adding in Excel
 

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.

Adding in Excel
 

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.

Adding in Excel
 

Use autosum

"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.