= one total two columns different text

[rtr7743]

I am trying to add a formula that will give me a total. I need it to look at
column b for Wash and then look at column h in the same row for OT and then
tell me how many have both words.

 

[Pete_UK]

Try this:

=SUMPRODUCT((B1:B1000="Wash")*(H1:H1000="OT"))

I've assumed you have 1000 rows of data - adjust if you have more.

Hope this helps.

Pete