formula to cross reference

hi guys
formulas i cannot get my head round at all

i need e14 to
work out how many times cell e1 appears in column h and in column b

so if yes is in e1
it then needs to look down column b and cross refernce it with column h and return the number of yes that appear in column b AND the same row in column h


thanks

Something like:

=Sumproduct(--(B1:B100=E1),--(H1:H100=E1))

adjust ranges to suit.

Hi
the formula below counts how many times the value in E1 appears on the same row in column B and column H, between rows 2 and 13. Adjust to your liking.

=SUMPRODUCT(--(B2:B13=E1),--(H2:H13=E1))

Is that what you need?