Hi everyone,

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

Tim.