VLOOKUP code needed please

[j4ymf]

hello
i have attached a file so you can see what my problem is
http://www.excelforum.com/attachment.php?attachmentid=4447&stc=1&d=1142190471

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 |
+-------------------------------------------------------------------+

 

[davesexcel]

=SUMIF(B5:B26,C3,A5:A26)
this example
c3 was the criteria ie:Good or Bad

B5:B26 is either good or bad

A5:A26 had the values to add up

 

[Peo Sjoblom]

=SUMIF($D$1:$D$50,"Good",$C$1:$C$50)

replace good with bad to get those values as well

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[j4ymf]

thanks dave you are the kiddie

just what i needed