I am trying to calculate costs for product we have to reship to patient,
taking into consideration whether or not we can receive credit from the
vendor. Here is the data.
Worksheet = jan
A B C D E
F
1 Ship Loc Ship Date Cost Order # Item
Return Reason
2 1 12/30/08 60.00 54585 Baseball bat
Damage
3 28 1/23/09 1.00 54858 Gatorade
Not needed
4 28 2/3/09 1000.00 58975 Team Uniforms Not
needed
5 1 12/28/09 50.00 68748 Glove
unknown
6 4 11/25/09 100.00 58789 Baseball cleats
wrong size
7 5 2/4/09 25.00 89758 Football
not needed

Worksheet = Summary
I want to calculate the cost of all returns with a reason not needed, where
we will not get any credit from vendor for the gatorade and the team
uniforms, but the average cost of everything else is the MSRP price which is
5% higher than our actual cost.