Sumnproduct formula

Thanks for the reply, column A determines if it should look at column b. I want it to look at all the cells in col A with 1 in. If they have a 1 in count all cells in col b that are under 10.

so it needs some sort of =IF function then a countif formula in the same cell but dont know how to do it.

Try this and let me know if it works:

=SUMPRODUCT(--(A1:A6=1),--(B1:B6<10))

That worked, thanks very much for your help.

Glad I could help.