Quote:
Originally Posted by ArviLaanemets
You got me fully confused! Are you writing about same formula, or another one? And what is denominator?
I'm quessing now. When you want in range Q50:C56 to get the number of non-empty cells, then use the formula
Code:
=7-COUNTIFS(Q50:C56,"")
|
My Apologies, it is complicated, {if you could only be in my mind: D} I'm working with the formula that you have kindly provided. The denominator is what is used to divide by, so when I'm working the average of all answered questions that is Q50 to Q56 (7 questions) the responses are added and divide by 7. If one of the questions was not answered and were left blank the denominator would be 6 (divide by 6). is it possible to account for the blank in the COUNT(A30:G30)?
Am I making any sense?
05-09-2019, 01:42 PM
Similar Threads
Calculations
Windows 10 
Office 2016
Threaded Mode