Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Updating Information Revised | New Users to Excel | |||
revised: help with calculating 3 part function in excel | Excel Worksheet Functions | |||
Revised dates in excel | New Users to Excel | |||
MacroHelp - Revised submission | Excel Discussion (Misc queries) | |||
n or U Revised ? | Excel Worksheet Functions |