A smarter AVERAGE() and COUNTIF(). - I have an issue where I cannot do a simple AVERAGE() computation.
I have a form where there are 20 number fields and when I do an Average() of all the 20 fields it will average based on 20 values even though I only put numbers on 5 of the fields. I am not sure why this is happening possibly the default value of a number is 0? and this 0 is placed in the field thatโs why it gets counted?
Maybe we can have a smarter AVERAGE() function? OR a COUNTIF() function that we can specify to count fields that have values โ> 0โ . I have checked the docs and appsheet does not seem to have the COUNTIF() function.
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |