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: - the presence of the (text) value c2 in column Data!$N$5:$N$1137 AND
- 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
Bookmarks