Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

=COUNTIF($A10:$K10;"yes") in L10 =COUNTIF($A10:$K10;"no") in M10 =COUNTIF($A10:$K10;"late") in N10 e.g.
Better enter the strings to look for in dedicated cells and replace the string constance by the respective references.

=SUMPRODUCT($A10:$K10="yes") in L10 and so on may look a bit strange, but is better than the above formula, imo.

(Read the help texts about functions. You may exclude many not usable for you.)

=COUNTIF($A10:$K10;"yes") in L10 =COUNTIF($A10:$K10;"no") in M10 =COUNTIF($A10:$K10;"late") in N10 e.g.
Better enter the strings to look for in dedicated cells and replace the string constance constants by the respective references.

=SUMPRODUCT($A10:$K10="yes") in L10 and so on may look a bit strange, but is better than the above formula, imo.

(Read the help texts about functions. You may exclude many not usable for you.)