d380013 New Member Feb 12, 2013 #1 Dear Friends , i want formula help pls refer my below link https://docs.google.com/file/d/0B57oFxKylXSFYXF1Nk5KcUNEUmM/edit?usp=sharing
Dear Friends , i want formula help pls refer my below link https://docs.google.com/file/d/0B57oFxKylXSFYXF1Nk5KcUNEUmM/edit?usp=sharing
vasim Member Feb 12, 2013 #2 Hi, You can use something like =COUNTIF(Range,"UP")/COUNTA(Range) =COUNTIF(Range,"DOWN")/COUNTA(Range)
Hi, You can use something like =COUNTIF(Range,"UP")/COUNTA(Range) =COUNTIF(Range,"DOWN")/COUNTA(Range)