Suppose you have a grid like below. The challenge before you is to count number of rows which have only single 1. See the grid, the yellow highlighted ones are containing 1 only once. The answer is 3 for this problem.
You have to give me a single formula for the same. The relevant Excel can be downloaded from Grid
Note – You may choose to post the response in comments section.