Answer the question
In order to leave comments, you need to log in
How to sum an array of strings with "n" count?
There is a table with a large array of data "electronic diary", you need to calculate "n" in rows, "n" teachers can write as "n\b" "n\a" "n", the formula for counting one line is quite simple = SUMPRODUCT (DLSTR(C3:S3)-DLSTR(SUBSTITUTE(C3:S3;"n";""))), but the question arose of how to count the number of these "n" from a set of strings, an array of strings:
($C$4: $S$4;$C$50:$S$50;$C$96:$S$96;$C$142:$S$142;$C$188:$S$188;$C$234:$S$234;
$C$280:$S $280;$C$326:$S$326;$C$372:$S$372;$C$418:$S$418;$C$464:$S$464;
$C$510:$S$510;$C$556:$S$556; $C$602:$S$602;$C$648:$S$648;$C$694:$S$694;
$C$740:$S$740;$C$786:$S$786;$C$832:$S$832;$C $878:$S$878)
has already broken his whole head, help me out.
Answer the question
In order to leave comments, you need to log in
Maybe,
={
"н/а";
INDEX(COUNTIF(IF(REGEXMATCH(C2:H21;"н");ROW(B2:B21));ROW(B2:B21)))
}
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question