here is =([f17-(count(d2:d16)*(d17/count(d2:d16))*(e17/count(d2:d16)))]^2)/((G17-COUNT(D2:D16)*(D17/COUNT(D2:D16))^2)*(H17-COUNT(D2:D16)*(E17/COUNT(D2:D16))^2))
[Edit - added backticks to show complete formula]
here is =([f17-(count(d2:d16)*(d17/count(d2:d16))*(e17/count(d2:d16)))]^2)/((G17-COUNT(D2:D16)*(D17/COUNT(D2:D16))^2)*(H17-COUNT(D2:D16)*(E17/COUNT(D2:D16))^2))
[Edit - added backticks to show complete formula]
Can this help?
Just a tip. If a function name isn’t changed to all upper case then you know that a problem exists there.
There is a [] sign pair in the formula. You can not use square brackets in a formula
f17-(count(d2:d16)(d17/count(d2:d16))(e17/count(d2:d16)))
Missing multiply signs *. You MUST use the * sign for marking of the multiplications.
Missing multiply signs *
Those are caused by the site using those for markup; so when OP didn’t mark the code using backticks or indenting by four spaces, they were “eaten” by engine. You may see them if you open the question for edit.
Arghhh! There are some strange properties of this site…