Thread: Problem> do not include 999 in calculations
View Single Post
 
Old 05-09-2019, 01:42 PM
will soar will soar is offline Windows 10 Office 2016
Novice
  
Join Date: Feb 2017
Posts: 14
will soar is on a distinguished road
Default
Quote:
Originally Posted by ArviLaanemets View Post
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?
Reply With Quote