Calculating AVG score don't work
Hello all again,
i have the following issue if someone can help me
i have a Scorecard board then one of the column is the Score. what i'm trying to do is calculate the total Avg score of that column. I try using two formula
2. =COUNTIF and =SUM then =SUM/COUNT
Both way comeback with "#DIV/0!" when using live data.
also i'm using Centigon Filtered Summary to sort the Column by name.
thanks in adavance for your help