Need a formula to return 1.

[serge]

I need a formula to return 1 if the number is between 1 and 7.
Or
What formula should be used to count cells that have numbers in it ?

both would be nice.

Thank you.
Serge.

 

[Tuelor]

=if(and(a1>0,a1<8),1,0)

=count(b1:b1)

Editing the above as appropriate

D

 

[Aladin Akyurek]

I need a formula to return 1 if the number is between 1 and 7.
Or
What formula should be used to count cells that have numbers in it ?

both would be nice.

Thank you.
Serge.

Also...

=AND(A2 >=1, A2 <= 7) + 0

By the way:

=COUNT(A2:A10)

counts any number from A2:A10.

=COUNTIF(A2:A10,1)

counts just the occurrences of 1.

=COUNTIF(A2:A10,">=1)-COUNTIF(A2:A10,">7")

counts all numbers between 1 and 7 from A2:A10.

The following is equivalent to the latter:

=SUMPRODUCT(--(A2:A10>=1),--(A2:A10<=7))

 

[serge]

Thank you to both of you for your various formulas, now I have plenty.
Serge.