Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding 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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding in Excel
=SUMIF(A1:A100,"us postal",B1:B100)
Adjust for your actual ranges. Gord Dibben MS Excel MVP On Sun, 7 Oct 2007 10:24:00 -0700, cb wrote: 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding in Excel
Thanks- typed in the replacement nothing happens after I hit enter.
"Gord Dibben" wrote: =SUMIF(A1:A100,"us postal",B1:B100) Adjust for your actual ranges. Gord Dibben MS Excel MVP On Sun, 7 Oct 2007 10:24:00 -0700, cb wrote: 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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding in Excel
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) "cb" wrote in message ... Thanks- typed in the replacement nothing happens after I hit enter. "Gord Dibben" wrote: =SUMIF(A1:A100,"us postal",B1:B100) Adjust for your actual ranges. Gord Dibben MS Excel MVP On Sun, 7 Oct 2007 10:24:00 -0700, cb wrote: 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. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding in Excel
Use autosum
"cb" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding leading zero in Excel | Excel Worksheet Functions | |||
Adding in Excel | Excel Discussion (Misc queries) | |||
Adding Tax in excel | Excel Worksheet Functions | |||
Adding in Excel | Excel Discussion (Misc queries) | |||
Adding on excel | New Users to Excel |