I have a spreadsheet which contains lots of items but i want Category 1 items.
what want to do is:
In an order, if Product is more then £150 its a boiler and if it's less then £150 is an accessory.
I want to see how many orders are there in total which have Boilers and out of these orders how many have Boilers +accessories.
Can someone help please.