countif match question

[bmuddy2]

Here is a minor challenge for someone.

Column B has either "days" , "afts" or "mids".
Column c has "molder" , "lead-op" or "helper".

How do I count the number of times "days" appears next to "molder" ?

Formula in A1. There are blank cells here.(if it matters)

 

[jbeaucaire]

Try this:

=SUMPRODUCT(--(B1:B100="days"), --(C1:C100="molder"))

 

[Yard]

Hi, try

=SUMPRODUCT(--(B1:B10="days"),--(C1:C10="molder"))

 

[bmuddy2]

Maybe that was too easy !

Thanks for the help.