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, 10 views)