I am trying to calculate the variance of a whole column but want to exclude the zeros and empty cells. Excel does not hace a var.s.if like there is an average.if function, so how do I write the formula? please help
I am trying to calculate the variance of a whole column but want to exclude the zeros and empty cells. Excel does not hace a var.s.if like there is an average.if function, so how do I write the formula? please help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks