Count a combination of numbers in a range

[TBertot107]

I am trying to see how many combinations of 1 & 2 are in a certain range: I have uploaded a picture of the ranges and formula i am using. Can anyone tell me what I am doing wrong?

The results I am getting is a combination of the first count being deducted from the 2nd count. See the image.

Thank you.

 

[Fluff]

Duplicate to: Counting multiple conditions in same range

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.