Back after two months with a back injury/broken rib.
Can anyone give me a calculation that will enable me to to the following -
In M8:M50 I have a one word category i.e. Quarter, Half, Full or 8.
In N8:N50 I have a discount column (always 20%).
In 08:050 I have a cost.
I want to know the numer of times Quarter appears in the range with 20% discount and the total cost
Then I want to know the number of times Quarter appears in the range without 20% discount and the total cost.
Then same for the other three categories
So I end up with eight calculations.
i.e. if there were 20 entries and 15 of them had 20% discount and the cost per entry was £10 I would want the result to be 15 Quarters at a cost of £120, and the other calculation would be 5 Quarters at a cost of £50.
Hope that makes sense