How to count special words in MS WORD using a formula?

Question

I've a regular table added into my Word file. Inside of this table I insert "yes" or "no", for example. And I want to count all cells with the word "yes".

In excel it is easy to do using a formula, but I don't know how to solve this in Word

=COUNT(table1 E3:E40,"yes")

The code above does not work - it throws a syntax error. I guess it , and/or " operator.

Is it possible to do such "complex" formulas in Word?

Answer 1

Unfortunately, no, Word does not have the same capabilities as Excel. Using field codes, a limited range of formula calculations is possible, but there are no special functions, such as CountA or CountIf.

This would require executing a macro to test the column's cells' values and write the result. Or an Excel worksheet could be embedded in the Word document.