Adding seperate vaules in a ROW.

[thunter5]

Hello. This is my first post so I hope do this right.

I am using Excel 2010 and have a QB report that converts to an excel spreadsheet. It lists the number of items I sold in the same row as the price by year. I want to be able to count the number of the items, and then the average price. The problem for me is I don't know how to break-out the "Price" verses the number of items sold when it's in a ROW.

I've tried several ideas on this and I think it will be a SUMIF or an =IF (Value=$) thing.

-- removed inline image ---

 

[thunter5]

Sorry. Was unable to add a picture of the layout. I hope my description of the problem is enough.
-- removed inline image ---