Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting rid of helping columns
I am using the formula =IF(purchaser=name at top of column,SUM(purchase
amount),0) in XL 2003 to find the expences of each person and placing that amount in a column to be sumed at the bottom. I then use that total to calculate costs and comissions. I have no need to see the list of purchases under each name but I don't know how to test each purchase for a name and add that to other purchases without a helping column. Is there some way to get around this? thanks, paul |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting rid of helping columns
Nevermind, I figured out how to use SUMIF.
"paulgallanter" wrote: I am using the formula =IF(purchaser=name at top of column,SUM(purchase amount),0) in XL 2003 to find the expences of each person and placing that amount in a column to be sumed at the bottom. I then use that total to calculate costs and comissions. I have no need to see the list of purchases under each name but I don't know how to test each purchase for a name and add that to other purchases without a helping column. Is there some way to get around this? thanks, paul |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting rid of helping columns
On Sat, 8 Apr 2006 15:09:02 -0700, paulgallanter
wrote: I am using the formula =IF(purchaser=name at top of column,SUM(purchase amount),0) in XL 2003 to find the expences of each person and placing that amount in a column to be sumed at the bottom. I then use that total to calculate costs and comissions. I have no need to see the list of purchases under each name but I don't know how to test each purchase for a name and add that to other purchases without a helping column. Is there some way to get around this? thanks, paul Sounds like you need SUMIF With purchaser in A2:A100, amounts in B2:B100, and purchaser name in A1 SUMIF(A2:A100,A1,B2:B100) HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |