Countifs function

Ok so I need to create a formula that does a couple of things I am not even sure if it is possible. I need to find a specific value in three different columns which I can do but I also need to pull dollar values from other columns that correspond with the rows the items are found in. Example: 

Column one contains a list of fruits, column two contains how many were sold, column 3 contains the dollar amount of the sale, column 4 contains how many of that fruit was good, column 5 contains how many of that fruit was bad, column 6 contains the dollar amount of credit given to the customer and column 7 contains the dollar amount less the credit. I want to break down each one in a report on a separate worksheet. 

 

Apples     65      $65.00      60     5      $5.00      $60.00

Bananas   65      $65.00      60     5      $5.00      $60.00

Pears        65      $65.00      60     5      $5.00      $60.00

Apples      65      $65.00      60     5      $5.00      $60.00

Bananas    65      $65.00      60     5      $5.00      $60.00

Apples      65      $65.00      60     5      $5.00      $60.00

Pears        65      $65.00      60     5      $5.00      $60.00

 

 

I need to show this for each fruit

 

Apples Total in sales = $130.00

Apples Total Credits = $10.00

Apples Total other Expenses = $20.00

Apples Total net sales = $100.00

 

I need the amounts to return automatically based on just the criteria for that one fruit at a time.

 

Any help on this would be appreciated.