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
You get better help if you add an excel file, without confidentional information.
Please also add the expected result (in the sheet).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Try this array formula
=VAR(IF(A:A<>0,A:A))
Confirm with Ctrl+Shift+Enter and not just Enter
Note, VAR like STDEV ignores blank cells while calculating
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks