You have a project that entails analyzing the competitors pricing. After collecting over a hundred prices on the items, you noticed the price ranges from a low of $99 to as high as $999. Another observation made is there are a number of products around the $499 range. To better organize and present the pricing data, you decided to group it into three categories (Value, Average, Luxury) first and then tally them up.

Which Microsoft Excel tools/functions would you use to categorize the prices and then tally them up? (could be more than one)

		LOOKUP function then COUNTIF function
		COUNTIF function then LOOKUP function
		Pivot Table then COUNTIF function
		COUNTIF function then Pivot Table