creating an equation

[Peggy]

I am trying to create an equation that will allow Excel to
look at a group of cells and tell me if there is any
numbers, and if so the cell to equal 1,(eg C2:C4)and if
not to equal 0 (eg B2:B4). Here is my sheet below.

A B C D
1 SAT SUN MON
2 ADULT TICKET 10
3 SENIOR TICKET 5 5
4 CHILD TICKET 10

 

[Frank Kabel]

Hi Peggy
one way:
=IF(SUMPRODUCT(1*ISNUMBER(B2:B4))>0,1,0)
copy this for all your rows
HTH
Frank

 

[Guest]

Frank you are so awesome. Thank you so much. It was
driving me crazy.
Peggy

 

[Frank Kabel]

Hi Peggy

thanks for the thanks
Frank

Frank you are so awesome. Thank you so much. It was
driving me crazy.
Peggy

 

[Peo Sjoblom]

Just another way

=(COUNT(B2:B4)>0)*1