View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Auditor Auditor is offline
external usenet poster
 
Posts: 2
Default Sum within a column, according to another column

I have two columns. One column contains the prices of each item sold. The
other column is called a line number and begins with one for new
transactions. So if a customer bought 4 items, it will go up to 4. Is there
any way to sum just those in a transaction, and then do it for hundreds of
other transactions?