In your original post, you asked:
< I am looking at adding the credits from row 2 through row 178
Now it seems that you have at least 393 sales!

You need to extend the range of the formula to include
all the rows that contain your credits.

Try: =SUMIF(D:D,"US Postal Service",H:H)

George Gee


"cb" wrote in message
...
Okay I replaced it with US Postal Service- the figure it gave me at the
bottom to the left of the column has to be incorrect, Because I estimate
what
it should be by avergaging 393 sales with a ship fee of about $15 per
sale, I
am looking at over 4K. It gives me a figure of just under $700


"George Gee" wrote:

What are the actual contents of the cells that contain the words us
postal?
For the formula to "work", the cells must only contain the words us
postal.
Try replacing "us postal" in the formula, with whatever is in the cells,
(you will
need to enclose the words within quotes "").

George Gee


"cb" wrote in message
...
I am adding this formula you wrote below in the browser bar. Nothing
happens
at the bottom I see the # 0
Is there another place or way to enter this formula?

"George Gee" wrote:


Why didn't you show us what formula you actually used?

Try this: =SUMIF(D2:D178,"us postal",H2:H178)

George Gee

"cb" wrote in message
...
I have a spreadsheet from Pay pal.
It lists many columns and cells.
For example in one of the COLUMNS (column D) it lists the words"us
postal"
which are postal fees I incurred, for debits and their are names
listed
beneath them as credits for paid sales. The actual numbers show in
column
H
that I need to add up that are currently showing as debits. I do not
want
to
add the credits in column H.


Since Column H shows debits and credits- I need to separate these
out
and
add the debits for total ship fees.

I want to add up only the "us postal" fees in total IN THE COLUMN H
that
show as debits, so I can get a total for the total ship fees paid.

How do I do this to separate this out?
The column listed for the postal fees starts with D2 and the column
listed
for the actual numbers that show as debits start in column H2

This formula was not working- or I did not replace the formula
correct.
So how do I do this?

I was given this formula, but it was not working . I replaced the
values
which I thought were correctly but it was not working.
=SUMIF(A1:A100,"us postal",B1:B100)

I am looking at adding the credits from row 2 through row 178