View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ndforty ndforty is offline
external usenet poster
 
Posts: 1
Default summing column c based an column a criteria

I have extracted reports where oil well numbers are in column A and a related
expense is in column C. I'm looking for a function to that will give me
total expenses per well number.

I've sorted the spreadsheet by well number and then put sum formulas that
add all the column c expenses for a given well number out to the side, but
this is very tedious with over 100 well numbers.

Is there an easier way?