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.
