I'm in quite a pickle here. I've done research and figured out some issues on my own, but this one has stumped me. I am doing a performance review and I am trying to get the average of multiple fields that contain calculations. Each field is either a dropdown formfield with a number or a bookmarked cell with a formula inside calculating an average. I need to create a formula that averages the five main parts (5th part is optional).

My work around to this was creating an if/else statement that would show either a 4 or 5 iF part 5 has a selection other than "0" in it to work on the overall average.

Here is my equation (not working):
{=({REF TS2}+{REF SS2}+{REF SRSA2}+{REF OD15}+{REF Clinical2})/{REF CPC1} \# 0}

OD15 is the cell with the average calculation that had the bookmark inserted
CPC1 is the if/else statement to make the average calculation easier.

Thank you for the help in advance.

Attached Files

Faculty Performance Review-FORUM.docx (91.8 KB, 8 views)

1. Your averaging formula field has the braces for the REF fields typed. You can't do that. They must be created via Insert|Cross-Reference for the bookmarks concerned, or via Ctrl-F9.
2. You can delete the CPC1 bookmark and field associated with it and simply code your averaging formula field as:
{=({REF TS2}+{REF SS2}+{REF SRSA2}+{REF OD15}+{REF Clinical2})/{IF{REF Clinical2}= 0 4 5} \# 0}
3. Your document contains a mix of formfields and content controls. These were not designed to work together in the same document and shouldn't be used that way; inconsistent document behaviour can result. Stick to one or the other.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

You are a god among men and women. Thank you so much for your help. I was scratching my head cause I figured you can just type in the formulas...LOL

I really appreciate your help.