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