Result showing 0 not sure how I'm going wrong

"David Biddulph" wrote:

Not COUNTIF, but:
=SUMPRODUCT((A1:A10="NUTS")*(B1:B10="BOLTS"))
--
David Biddulph


"Andy K" wrote in message
...
Cells A1: A10 and B1:B10 have a list of components "NUTS" and "BOLTS" I
would like to use countif to total the number of times I see NUTS but only
if
bolts can be seen in the same row
A B
1 NUTS BOLTS 1
2 SCREWS BOLTS
3 NUTS WASHERS
4 NUTS WASHERS
5 SCREWS BOLTS
6 SCREWS WASHERS
7 SCREWS WASHERS
8 NUTS WASHERS
9 SCREWS WASHERS
10 NUTS BOLTS 1
Total 2

Thanks in advance