How many unique products in a price band

Hi Steven811

Try the following, the price criteria is hard coded, so you might to consider putting them into cells and referencing them.
In G3 and copy down:

Formula:

Please Login or Register  to view this content.

In H3 and copy down:

Formula:

Please Login or Register  to view this content.

They are both array formulas,so to commit them. CTRL + SHIFT + ENTER

hi Steven 811, another alternative array formula. in G3:

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL-SHIFT-ENTER to activate the array. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL-SHIFT-ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again. change the one in red for H3 to be 4 & 6

try this array then:
=SUM(SIGN(FREQUENCY(IF($E$2:$E$17>=1,IF($E$2:$E$17<=3,MATCH($D$2:$D$17,$D$2:$D$17,0))),ROW($D$2:$D$17)-ROW($D$2)+1)))

That seams to have got it.

Thanks to everyone for help.

As always I'm indebted to the forum members