 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007Adding in Excel
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. =SUMIF(A1:A100,"us postal",B1:B100) Adjust for your actual ranges. Gord Dibben MS Excel MVP >I have a spreadsheet from Pay pal. >It lists many columns and cells. [quoted text clipped - 3 lines] >I want to add up only the "us postal" fees in total. >How do I do this to separate this out. Thanks- typed in the replacement nothing happens after I hit enter. > =SUMIF(A1:A100,"us postal",B1:B100) > [quoted text clipped - 9 lines] > >I want to add up only the "us postal" fees in total. > >How do I do this to separate this out. 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).  SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) > Thanks- typed in the replacement nothing happens after I hit enter. > [quoted text clipped - 13 lines] >> >I want to add up only the "us postal" fees in total. >> >How do I do this to separate this out. Use autosum > I have a spreadsheet from Pay pal. > It lists many columns and cells. [quoted text clipped - 3 lines] > I want to add up only the "us postal" fees in total. > How do I do this to separate this out.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.