BACKGROUND
I have two sheets: ANALYSIS and DATA. The formula is in sheet ANALYSIS, the data in sheet DATA.

TASK
I need to count the unique (text) values in column Data!$f$5:$f$1137, based on two criteria:
  1. the presence of the (text) value c2 in column Data!$N$5:$N$1137 AND
  2. the presence of the (text) value $B$2 in column Data!$L$5:$L$1137

FAULTY FORMULA
The formula I tried to use reads as follows:
=SUM(IF((c2=Data!$N$5:$N$1137)*
(Data!$L$5:$L$1137=$B$2)),
1/(COUNTIFS(Data!$N$5:$N$1137,c2,
Data!$f$5:$f$1137,Data!$f$5:$f$1137,
Data!$L$5:$L$1137,&Data!$N$5:$N$1137)), 0))
Ctrl Shift Enter

RESULT
Whatever I try, I continue to get a “The formula you typed contains an error”

REQUEST
Can someone tell me what the error in my formula is?
PS: I need to resolve the above, before I can start on a separate analysis to count unique (text) values, not on two but on three criteria.

Thanking the forum in advance,
Gijs