Adding in Excel

[Guest]

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.

 

[Gord Dibben]

=SUMIF(A1:A100,"us postal",B1:B100)

Adjust for your actual ranges.


Gord Dibben MS Excel MVP

 

[Guest]

Thanks- typed in the replacement nothing happens after I hit enter.

 

[Chip Pearson]

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)

 

[Guest]

Use autosum