I used countif and sumif functions and got correct results but from one criteria (east) got zero output again and again even using same formula for others criteria and got correct results but don't know why I am getting zero output from such one criteria(east)