| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP code needed please
hello i have attached a file so you can see what my problem is http://www.excelforum.com/attachment...d=114219047 1 what i need to be able to do is calculate all the good and bad figures can anyone help me with a script many thanks jason ie: 35187 Good 17096 Good 4424 Good 3091 Good 2455 Good 2023 Good 1121 Good 691 Good = 66088 etc 55 Bad 9388 Bad 5620 Bad 3498 Bad 3093 Bad 2120 Bad 1501 Bad 1073 Bad 788 Bad 762 Bad 275 Bad 275 Bad =28448 so i need a code that looks for all the good and adds them up and like wise with the bad thanks +-------------------------------------------------------------------+ |Filename: VLOOKUP problem.JPG | |Download: http://www.excelforum.com/attachment.php?postid=4447 | +-------------------------------------------------------------------+ -- j4ymf ------------------------------------------------------------------------ j4ymf's Profile: http://www.excelforum.com/member.php...o&userid=32389 View this thread: http://www.excelforum.com/showthread...hreadid=521529 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you entre a bar code into a excel cell? | Excel Worksheet Functions | |||
| School-boy secret code help needed | Excel Discussion (Misc queries) | |||
| Sumproduct with a vLookup, multiple criteria | Excel Worksheet Functions | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| formula / code help needed | Excel Discussion (Misc queries) | |||
Threaded Mode
