| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif with detail
Hi all,
I have sheet, A1 is name, B1 is amt and C is result. I want to sum of amt who is late and ontime. and also wants name who is late or ontime. can it is possible. please help me and tell me how is possible. I can show u example. A1 B1 C1 Name amt Result a 100 late b 200 ontime c 300 late d 400 late e 500 ontime f 600 ontime g 700 ontime h 800 late sum of late 1600 (a,c,d,h)---- name of late person sum of ontime 2000 (b,e,f,g)---- name of ontime person please help me thanks RKS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forgot a little detail, Peo Sjoblom | Excel Discussion (Misc queries) | |||
| IF Dilema detail | Excel Discussion (Misc queries) | |||
| day of week without detail | Excel Discussion (Misc queries) | |||
| grab detail when = 1 | Excel Worksheet Functions | |||
| Show detail | Excel Worksheet Functions | |||
Threaded Mode
