I need some assistance in Word 2007 using calculating form fields in a table. The final table references other tables in the document. The problem is when one of the cells from the other tables has a 0 zero it brings the average down in the final table. How would I average the cells and not count the 0?
I have tried =sum(b1:b8)/countif(b1:b8,">0") but I keep receiving a syntax error. I am really not sure how to use countif or sumif but someone on the programming staff suggested it may be possible.
Thank you for any assistance