Question

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

Answer 1

Countif is not worthy here, it will just provide you with no. Of items that are in each group.

But if you want to group each of them then there are more than 100 ways but most efficient would be-

to use If formula to first check the price with the desired range & if it satisfies than name it Value or Luxury or Average, whichever statement it satisfies.

Than use pivot.

Formula

=If(Price>450,"Value",If(Price>550,"Average"),"Luxury")

This will place the name of group in every row.

Hope this makes contribution to your success. Hit Like to motivates the experts to provide quality solutions.

Any feedback will also be appreciated.

Best of luck?!