| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable criteria formula
Column 'A' contains 2-digit codes (i.e. LB, BA, BB, etc.).
Column 'C' contains dates (mm/dd/yy format) Column 'L' contains mileage figures. Attempting to write a formula that will calculate mileage (Col. L) by a specific code (Col. A) and a certain date (Col. C). For example, total mileage for all 2005 dates that have code "LB". This is probably simpler than I am making it out to be. Any help is appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM formula - using variable values | Excel Worksheet Functions | |||
| Formula that only adds numbers that meet specific criteria | Excel Discussion (Misc queries) | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
| Data Validation - Scroll in the formula bar for a custom criteria | Excel Worksheet Functions | |||
| use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
Threaded Mode
