Calculations of dropdowns and formfield averages
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.
|