Adding in Excel

C

cb

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

Gord Dibben

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

Adjust for your actual ranges.


Gord Dibben MS Excel MVP
 
C

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top