| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel formulas
I need to calculate a sum using 2 different date ranges...example
Col A Col B 11/29/04 500 11/30/04 2 12/01/04 600 12/02/04 300 I cannot get SUMPRODUCT to work as it will only calc <=11/30/04 or <=12/02/04 but not both. The sum I am looking for would be Nov04=502 and Dec04=900. Does this make sense or is it hopeless? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| Suddenly cannot calculate functions or formulas in Excel | Excel Worksheet Functions | |||
| How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions | |||
| IF/AND formulas within excel | Excel Discussion (Misc queries) | |||
| Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions | |||
Threaded Mode
