Help If a cell contains specific text count adjacent cell

[Kellis]

Hello all

I am struggling to find an answer for this. I am not sure even if a CountIF formula is best or Sumproduct. At the moment I am going a long way round by counting cells with certain text and then counting cells which are blank and subtracting

=SUMPRODUCT(--('HV Log '!F1:F106="job number")*('HV Log '!H1:H106=""))

What I am looking for is formula to find all cells with 'Job Number' and then count the adjacent cell if there is a job number (Job numbers consist of letter and number)

Any suggestions?

 

[Luke M]

You're SUMPRODUCT works pretty well, or you can use:
=COUNTIFS(F1:F106,"job number",H1:H106,"<>")
Which says to count number of rows which have "job number" in col J, and something in col H.

 

[Kellis]

Thanks, great.