Count unique (text) values based on two criteria

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

Something like this, CSE formula. But is hard to guess, so a sample would be better:

=SUM(IF(FREQUENCY(IF(Data!$N$5:$N$1137=$C2,IF(Data!$L$5:$L$1137=$B$2,IF(Data!$f$5:$f$1137<>"",MATCH(Data!$f$5:$f$1137,$Data!$f$5:$f$1137,0)))),ROW(Data!$f$5:$f$1137)-ROW(Data!$f5)+1),1))

Thank you Paul, for the instant response.

There was a small error in your formula, but that was easy to fix:
=SUM(IF(FREQUENCY(IF(Data!$N$5:$N$1137=$C2,IF(Data!$L$5:$L$1137=$B$2,IF(Data!$f$5:$f$1137<>"",MATCH(Data!$f$5:$f$1137,$Data!$f$5:$f$1137,0)))),ROW(Data!$f$5:$f$1137)-ROW(Data!$f5)+1),1))

The formula works like a charm, except for one value that returns a #VALUE!

I have however two follow-up question:

1. Is the SUM IF FREQUENCY a better formula then the SUM IF COUNTIFS?
2. Since I have several worksheets to work this formula on, with an excess of date (>6,000 rows), is it recommended to use an entire column (e.g. Data!$N:$N) instead of the specific cells in the column Data!$N$5:$N$1137 Or will this slow the formula down?

Thanks again Paul!

Originally Posted by Jacc

If you attach a workbook (not pictures) with some data and the expected output it will be much easier to help you.

Please find attached the workbook. Thanks for the help!