Excel 2007 : Adding multiple cells contingent upon another

I need help trying to come up with a formula to calculate the summation of column B contingent upon the "WORK ORDER" column containing a value >0, the total to be in G6. So when I get a work order number inputted in column C it keeps a running total of the price associated next to it in column B through the entire spreadsheet. The exception to the total summation would be if there was a price inputted with no work order number next to it, then the cell would not be added to the total dollar amount.

In G6 try =SUMIF(C2:C100,">0",B2:B100)

Is that what you're after?

Andrew,
Props to you man, what an ACE. Thanks all for all your help