hi all,
I need help to write count formula. I want to count for each Fruit type, the number of cell in column B is 0 or blank .
there is formula in column B, so if it blank, means the formula return a blank value . Count still return 1 if the value is blank because the formula is there, but i want it return 0
Thanks.
I need help to write count formula. I want to count for each Fruit type, the number of cell in column B is 0 or blank .
there is formula in column B, so if it blank, means the formula return a blank value . Count still return 1 if the value is blank because the formula is there, but i want it return 0
Thanks.