Counting problem

  • Thread starter Thread starter vwchurch1955
  • Start date Start date
V

vwchurch1955

I have three columns of single digit numbers, example...

A1=7, B1=8, and C1=9
A2=3, B2=4, and C2=5

I want to concatenate these three digits so EXCEL looks at them as i
they were one number ie. "789" - "345" and then count them based on tw
criteria. For example; count concatenated digits > 600 and < 850.

Can someone please HELP!

Thank you whomever you are. : -
 
Hi

=SUMPRODUCT((((A1:A2)&(B1:B2)&(C1:C2))*1>600)*(((A1:A2)&(B1:B2)&(C1:C2))*1<8
50))
 
I have three columns of single digit numbers, example...

A1=7, B1=8, and C1=9
A2=3, B2=4, and C2=5

I want to concatenate these three digits so EXCEL looks at them as if
they were one number ie. "789" - "345" and then count them based on two
criteria. For example; count concatenated digits > 600 and < 850.

Can someone please HELP!

Thank you whomever you are. : - )
Click to expand...

You could use the *array-entered* formula:

=SUM(((A1:A10*100+B1:B10*10+C1:C10)>600)*((A1:A10*100+B1:B10*10+C1:C10)<850))

To *array-enter*, hold down <ctrl><shift> while hitting <enter>. XL will place
braces {...} around the formula


--ron
 
Back
Top