T
T
T999EA2021-09-03 18:54:26
Google Sheets
T999EA, 2021-09-03 18:54:26

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.
6132452c06775320361418.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Ivanov, 2021-09-04
@T999EA

Maybe,

={
  "н/а";
  INDEX(COUNTIF(IF(REGEXMATCH(C2:H21;"н");ROW(B2:B21));ROW(B2:B21)))
}

613388452500a280366080.png
Example in Spreadsheet https://docs.google.com/spreadsheets/d/1V7MbFBvaIM...

D
dollar, 2021-09-03
@dollar

Sum the column with the results of counting each row.
(if I understood the question correctly)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question