Sumproduct formula that includes an or option

[carbonbianchi]

Hi, I am trying to use a Sumproduct formula that looks in column B (B4:B64) for whatever is in cell D111 eg "Cardiology" then looks in column H (H4:H64) for EITHER the word "NA" or a number greater than zero. I tried the following:

SUMPRODUCT(--($B$4:$B$64=$D111)*--(H$4:H$64="NA")+(H$4:H$64>0)) but it isnt calculating correctly.

Can anyone help me? Thanks in advance

PS I cant post the worksheet as this contains patient data but have screenshotted the relevant data.
Annotation 2020-07-14 103943.jpg

[XLent]

=SUMPRODUCT(($B$4:$B$64=$D111)*SIGN((H$4:H$64="NA")+(H$4:H$64>0)))

that said, "NA" (string) is > 0 so, based on screenshot, I doubt you need the OR... i.e. solitary >0 test would suffice

if the values in your table are either NA, 0 or >0 then you might find you could get away with COUNTIFS

=COUNTIFS($B$4:$B$64,$D111,H$4:H$64,"<>0")

[TMS]

Please see the yellow banner and post a sample workbook.

[carbonbianchi]

Worked perfectly-thanks so much!! I hadnt picked up on the text being >0 either. Every day is a school day!!