Count total values between -1.00 and 1.00 1

[cjbrown815]

Excel 2010-
I have 14 columns, each row has 14 values under each column. I need a count of all values that are between -1.00 (negative one) and 1.00

thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[Andrzejek]

Would this be any help?

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[Andrzejek]

How about counting the number of cells with values greater than or equal to -1, and subtracting the number of cells with the values greater than 1?

Something like:[tt]
=COUNTIF(A2:N2,">= -1") - COUNTIF(A2:N2,"> 1")[/tt]


Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[mintjulep]

Use COuNTifS() according to the following example for MS Help.

=COUNTIFS(A2:A7,"<6",A2:A7,">1")

Counts how many numbers between 1 and 6 (not including 1 and 6) are contained in cells A2 through A7.