| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| summing values in a data table based on criteria in another column | Excel Worksheet Functions | |||
| calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
| Summing one column based on date in another column | New Users to Excel | |||
| move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
| Counting & Summing based on criteria on another column | Excel Discussion (Misc queries) | |||
Threaded Mode
