Hi

I need to identify how many unique coloured products are in one of two price bands.

Totalling in separate columns

Enclosed is an example of the problem.

Any ideas would be gratefully received.

Thanks Steven811

Sum if in range.xlsx