Large Word documents are often sprinkled with references to information throughout a document. You can enter them manually, but they'll be hard to maintain later. Instead, use this simple technique.

It’s important to note that this function ignores blank and text values. The second argument, criteria, can be a number, expression, text string or cell reference that specifies which cells to ...