i have a column (column B) of cells with numbers in the cells. i want to
count for. example, how many cells have a number between 12 and 29. i used
=countif(B:B,"=12 and <=29") but it did not work. =countif(B:B,"=12,<=29")
also did not work. what is the correct syntax for the criteria in the
formula?

thanks for your help
fred

=COUNTIF(B:B,"<30")-COUNTIF(B:B,"<12")

--
Gary''s Student - gsnu200802

try
=sumproduct((b2:b22=12)*(b2:b22<=29))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fred Loh" wrote in message
...
i have a column (column B) of cells with numbers in the cells. i want to
count for. example, how many cells have a number between 12 and 29. i used
=countif(B:B,"=12 and <=29") but it did not work.
=countif(B:B,"=12,<=29")
also did not work. what is the correct syntax for the criteria in the
formula?

thanks for your help
fred

=SUM(COUNTIF(B:B,{"=12","29"})*{1,-1})


"Fred Loh" wrote:

i have a column (column B) of cells with numbers in the cells. i want to
count for. example, how many cells have a number between 12 and 29. i used
=countif(B:B,"=12 and <=29") but it did not work. =countif(B:B,"=12,<=29")
also did not work. what is the correct syntax for the criteria in the
formula?

thanks for your help
fred

thanks guys!

Gary's Student's solution works and the logic makes sense.

Teethless mama's solution also works but I don't understand why the need to
multiply {1,-1}

i can't get Don's solution to work. i have a "#NUM!" error.

Sumproduct does not take full columns. Must use a range as I did a2:a???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fred Loh" wrote in message
...
thanks guys!

Gary's Student's solution works and the logic makes sense.

Teethless mama's solution also works but I don't understand why the need
to
multiply {1,-1}

i can't get Don's solution to work. i have a "#NUM!" error.

It works! Thanks Don.

"Don Guillett" wrote:

Sumproduct does not take full columns. Must use a range as I did a2:a???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fred Loh" wrote in message
...
thanks guys!

Gary's Student's solution works and the logic makes sense.

Teethless mama's solution also works but I don't understand why the need
to
multiply {1,-1}

i can't get Don's solution to work. i have a "#NUM!" error.

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fred Loh" wrote in message
...
It works! Thanks Don.

"Don Guillett" wrote:

Sumproduct does not take full columns. Must use a range as I did a2:a???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fred Loh" wrote in message
...
thanks guys!

Gary's Student's solution works and the logic makes sense.

Teethless mama's solution also works but I don't understand why the
need
to
multiply {1,-1}

i can't get Don's solution to work. i have a "#NUM!" error.