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))
Bookmarks