LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
CB CB is offline
external usenet poster
 
Posts: 97
Default Adding in Excel Revised

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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Updating Information Revised JohnM New Users to Excel 2 August 3rd 07 04:42 PM
revised: help with calculating 3 part function in excel monkeytrader Excel Worksheet Functions 1 October 1st 06 05:40 AM
Revised dates in excel Fifee New Users to Excel 2 August 24th 06 06:25 PM
MacroHelp - Revised submission John Britto Excel Discussion (Misc queries) 1 October 15th 05 02:58 PM
n or U Revised ? Blessingspoint Excel Worksheet Functions 1 January 18th 05 08:43 PM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"