| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum for match criteria
I am trying to get a sum of part cost for each year
I have a table with dates that are between 39814 (2007) and 40908 (2011) this is Column A, in column D are the prices for the parts So I want to find the sum of all part costs purchased between 39814 and 39813 (2007) then I will do the same for 2008,2009, 2010 etc. Any suggestions -- Neall |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
| Match criteria with an array of criteria | Excel Worksheet Functions | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
| match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
| Match 2 Criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
