I am relatively new to excel subtotal functions. Here is my problem. I need to find an average of
ages, so I cant use either 0 or null in my average function. Though 0 or null mean the same in this case, as i cant control
user entered data, I cant alter what they entered.
For example for the above data , if i filter for different states, I should get respective averages of that state, excluding
0s and nulls. I need to embed the function inside a java program that will generate the excel, so its really hard for me to
use something like below.
the above worked but it
always shows, #VALUE for the first time and only when I go to the function "fx" space and then hit enter, it
converts #VALUE to number.