C Carla Jun 25, 2004 #1 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.
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.
P Peo Sjoblom Jun 25, 2004 #2 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)
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)
G Guest Jun 25, 2004 #3 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) . Click to expand...
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) . Click to expand...
G Guest Jun 25, 2004 #4 =OR(logical, logical) and =AND(logical, logical) Are themselves worksheet functions.
