IF AND OR COUNTIF help needed

[knifey]

Hi,
I'm trying (without much success) to build a rather complex formula. The first part marked in green is working.

What I've got so far:
=IF(AND(master!C3:C2002="Rx",master!Q3:Q2002="NA"),COUNTIFS(master!C3:C2002,"Rx",master!Q3:Q2002,"NA",master!N3:N2002,""),IF(OR(AND(master!C3:C2002="Rx",master!Q3:Q2002<>"NA",master!N3:N2002,""),AND(master!C3:C2002="Rx",master!Q3:Q2002<>"NA",master!R3:R2002,"")),COUNTIF(master!R3:R2002,"")))

What this should be doing (in plain English):
IF column C = "Rx" AND column Q = "NA" THEN
Count blanks in Column N
ELSEIF column C = "Rx" AND column Q <> "NA" AND column N = "" OR _
column C = "Rx" AND column Q <> "NA" AND column R = "" THEN
Count blanks in Column N or R
ENDIF

I could do this quite easily in VBA but my new boos is a formula freak!
Any advice or pointers would be much appreciated.

K

 

[PHV]

Please, for excel formula questions, ask here:
forum68

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[knifey]

Thanks PHV