Calculations in Word Tables?

**MKR** · 03-20-2013, 11:30 PM

Hi! I'm creating an evaluation form in a Word document (I have 2010 at work). The form requires counting ranked columns (see screenshot): The person gets a 5 if they're excellent, a 4 if they're satisfactory, etc. Then these scores are averaged to get the overall score for the category. This is quite easy to do in Excel, however, the users wish to have a form in word. I was trying to embed Excel objects, so that the formulas would remain intact, but it just made the form ugly and clumsy. There will be several of these evaluations done, so I don't want to link these to an Excel table.

Here's the formula I've used in Excel: =((COUNTIF(B51:B54,"x")*5)+(COUNTIF(C51:C54,"x")*4)+(COUNTIF(D51:D54,"x")*3)+(COUNTIF(E51:E54,"x")*2)+(COUNTIF(F51:F54,"x")))/4

Is there any way to make something like this in a Word table? Would a macro work? (If that's the case, I'm going to need assistance.)

Thank you!
Marianne

**macropod** · 03-21-2013, 03:30 AM

Hi MKR,

Word doesn't have an equivalent to Excel's countif function. Technically, you could achieve your aim without macros via the use of dropdown formfields, but that would leave open the possibility of a user selecting multiple scales for the same item. For a performance review implementation using macros with content control checkboxes (requires Word 2010 or later), see:
http://www.msofficeforums.com/word-t...html#post33489

**MKR** · 03-21-2013, 10:39 AM

Thank you so much for your help. I'm looking at the post you recommended and I think I'm going to try to adopt that format. What a great resource this forum is.

Thank you again,
Marianne