OR statement inside a COUNTIF statement

[Carla]

I am trying to get a formula that will count numbers
within a range that begin with a 1 OR 2 OR 3 OR 4.

Thank you.

 

[Peo Sjoblom]

One way

=SUMPRODUCT(--(LEFT(TRIM(A1:A20))={"1","2","3","4"}))

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Guest]

Thank you! You are awesome! It's works great!

-----Original Message-----
One way

=SUMPRODUCT(--(LEFT(TRIM(A1:A20))={"1","2","3","4"}))

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)





.

 

[Guest]

=OR(logical, logical) and
=AND(logical, logical)

Are themselves worksheet functions.