Getting rid of helping columns

P

paulgallanter

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
 
R

Richard Buttrey

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
Click to expand...


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
__________________________
 
Top