adding two fields if one is blank.

  • Thread starter Thread starter Actaeon
  • Start date Start date
A

Actaeon

Howdy!

Problem Line:
=COUNTIF(NAME!K:K,"JOE")+COUNTIF(NAME!L:L,"SMITH")

This line adds up to many cells for me, so to limit it further, I need
to count those lines that match the above limits but do NOT have any
data in M:M.

Failing Line:
=COUNTIF(NAME!K:K,"JOE")+COUNTIF(NAME!L:L,"SMITH")+COUNTIF(NAME!M:M,
"")

Doesn't work...just counts all the blank lines

Thank you for any help you can offer!
 
One way

=SUMPRODUCT((NAME!K1:K1000="JOE")*(NAME!L1:L1000="SMITH")*(NAME!M1:M1000="")
)

note that you cannot use the whole column K:K so instead try to use
something that is closer to your range since I doubt you have >65000 names
 
Back
Top