Hi

Im trying to make a formula that will multiply all numbers in an area based on a criteria, for instance multiply the numbers in column B in the below table based on the criteria "Blue" in column A. The formula should give the result 12, ie 2*3*2. Im familiar with the SUMPRODUCT but that will add the 3 numbers, ie 2+3+2, and I have also been messing with the PRODUCT formula and those 2 together, but I cant seem to make it work, so it multiplies the 3 numbers.

Any help greatly appreciated


A B
1 Blue 2
2 Red 2
3 Blue 3
4 Red 3
5 Blue 2