| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date wise Sum Formula required
I have date, Qty code & Quantity.
08-03-2007 1 X 40 1 11-03-2007 2 X 20 2 11-03-2007 8 X 20 8 14-03-2007 1 X 20 1 30-03-2007 1 X 20 1 18-03-2007 1 X 20 1 18-03-2007 2 X 20 2 18-03-2007 1 X 20 1 21-03-2007 2 X 20 2 Note-The qty in the 3dr colm are got by simply placing the formula =MID(A2:A$9,1,1) But I need formula to sum Qty date wise. And important is that to avoid result repetition where the date repeats in some cells. Help me please. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formula required | Excel Worksheet Functions | |||
| Turn 10106 in to 1st of JAN 2006, date wise I can't do it please h | Excel Discussion (Misc queries) | |||
| Data row wise, formula column wise | Excel Discussion (Misc queries) | |||
| Delete row wise duplicates & colomun wise simultaneously excel | Excel Worksheet Functions | |||
| addition to my date formula...required | Excel Worksheet Functions | |||
Threaded Mode
