Word CountIf Function for a table?

Question

Hi everyone-

I am working on an assignment for a college course that requires us to use Word to count and calculate data in a table. I am wondering how to count the instances of a number in a column. I have a column of data with a selection of either '1' or '2' in the column. I want to separate these out to count each occurrence of the value.

I know this would be easiest to do in Excel. Simply using CountIf would be a breeze. However, for whatever reason the professor wants this done in Word using Word functions...

Answer 1

Word has no equivalent to Excel's COUNTIF function. To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:

http://windowssecrets.com/forums/showthread.php/154369-Microsoft-Word-Field-Maths-Tutorial

or:

http://www.gmayor.com/downloads.htm#Third_party

Answer 2

The simplest way would be to embed a spreadsheet in the Word document.

Can you give us examples of what you need to do

Counting Values in Table Cells

http://word.tips.net/T000528_Counting_Values_in_Table_Cells.html

Summary: In Excel it is easy to count how many times a certain character occurs in a column of cells. In Word, it is a bit trickier. It could be done with a macro, but there is an even easier way, as described in this tip.

How to Total Rows and Columns in a Word 2013 Table

http://www.howtogeek.com/165464/how-to-total-rows-and-columns-in-a-word-2013-table/

Use a formula in a Word table

http://office.microsoft.com/en-us/word-help/use-a-formula-in-a-word-table-HA102329800.aspx