count them number of cells between values -2 and 2 including 0

I have a list of data I would like to count the number of cells that have the
following data -2, -1, 0, 1, 2.

=SUMPRODUCT(--(A1:A10>=-2),--(A1:A10<=2)) will give total number of cells
with value between -2 to +2

For individual counts:

=COUNTIF(A1:A10,"=-2") etc

HTH

"Helppppppppppppppppppppppppppppp" wrote:

> I have a list of data I would like to count the number of cells that have the
> following data -2, -1, 0, 1, 2.
>
>

Hi!

Try one of these:

=COUNTIF(A1:A10,">=-2")-COUNTIF(A1:A10,">2")

=SUMPRODUCT(--(ISNUMBER(A1:A10)),--(A1:A10>=-2),--(A1:A10<=2))

Biff

"Helppppppppppppppppppppppppppppp"
<Helppppppppppppppppppppppppppppp@discussions.microsoft.com> wrote in
message news:F8FAF26F-FFD9-44C5-AB7A-BBD153CF0352@microsoft.com...
>I have a list of data I would like to count the number of cells that have
>the
> following data -2, -1, 0, 1, 2.
>
>