You are reading a single comment by @CYOA and its replies. Click here to read the full conversation.
  • This is working:

    =if(sum(D6:K6), sumproduct(D6:K6,D6:K6,$D$5:$K$5)/(10*sumproduct($D$5:$K$5,$D$5:$K$5)))
    

    Cheers for help!

About

Avatar for CYOA @CYOA started