Formula for < and results
 

a b
1 Sue 8
2 Ann 5
3 Sue 4

I would like a formula if A=Sue and B is =4 but =<6 the result is 1.

THANK YOU!!!!

Formula for < and results
 

You didn't say what you wanted if the formula evaluated as false so this one
returns Unspecified.

=IF(AND(A1="Sue",AND(B1=4,B1<=6)),1,"Unspecified" )

Mike

"TMF in MN" wrote:

a b
1 Sue 8
2 Ann 5
3 Sue 4

I would like a formula if A=Sue and B is =4 but =<6 the result is 1.

THANK YOU!!!!

Formula for < and results
 

7ou're right, I did not clarify. I would like the formula to read column A
and column B so that the formula will count how many times Sue's numbers are
between 4 and 6, how many times Ann's numbers are between 4 and 6.... then
between 7 and 10.... 11 and 15... etc. THANK YOU!!!

"Mike H" wrote:

You didn't say what you wanted if the formula evaluated as false so this one
returns Unspecified.

=IF(AND(A1="Sue",AND(B1=4,B1<=6)),1,"Unspecified" )

Mike

"TMF in MN" wrote:

a b
1 Sue 8
2 Ann 5
3 Sue 4

I would like a formula if A=Sue and B is =4 but =<6 the result is 1.

THANK YOU!!!!

Formula for < and results
 

And of course you don't need the extra AND().
=IF(AND(A1="Sue",B1=4,B1<=6),1,"Unspecified")
--
David Biddulph

"Mike H" wrote in message
...
You didn't say what you wanted if the formula evaluated as false so this
one
returns Unspecified.

=IF(AND(A1="Sue",AND(B1=4,B1<=6)),1,"Unspecified" )

Mike

"TMF in MN" wrote:

a b
1 Sue 8
2 Ann 5
3 Sue 4

I would like a formula if A=Sue and B is =4 but =<6 the result is 1.

THANK YOU!!!!

Formula for < and results
 

I tried this but of course it didn't work!!!
countIF(AND(A1:A5="sue",AND(b1:b5=4,B1:B5<=6)),1)

"David Biddulph" wrote:

And of course you don't need the extra AND().
=IF(AND(A1="Sue",B1=4,B1<=6),1,"Unspecified")
--
David Biddulph

"Mike H" wrote in message
...
You didn't say what you wanted if the formula evaluated as false so this
one
returns Unspecified.

=IF(AND(A1="Sue",AND(B1=4,B1<=6)),1,"Unspecified" )

Mike

"TMF in MN" wrote:

a b
1 Sue 8
2 Ann 5
3 Sue 4

I would like a formula if A=Sue and B is =4 but =<6 the result is 1.

THANK YOU!!!!

Formula for < and results
 

=SUMPRODUCT(--(A1:A3="Sue"),--(B1:B3=4),--(B1:B3<=6))
or
=SUMPRODUCT((A1:A3="Sue")*(B1:B3=4)*(B1:B3<=6))
--
David Biddulph

"TMF in MN" wrote in message
...
7ou're right, I did not clarify. I would like the formula to read column
A
and column B so that the formula will count how many times Sue's numbers
are
between 4 and 6, how many times Ann's numbers are between 4 and 6....
then
between 7 and 10.... 11 and 15... etc. THANK YOU!!!

"Mike H" wrote:

You didn't say what you wanted if the formula evaluated as false so this
one
returns Unspecified.

=IF(AND(A1="Sue",AND(B1=4,B1<=6)),1,"Unspecified" )

Mike

"TMF in MN" wrote:

a b
1 Sue 8
2 Ann 5
3 Sue 4

I would like a formula if A=Sue and B is =4 but =<6 the result is 1.

THANK YOU!!!!