Data counting from different sheets !

[alinpion]

Hello!

I want to count every time whet a cell calue is equal to 0 , different than 0 and cell value varies between -5 and + 5 ; every time when one of this conditions is met the formula will wount 1 and place it in corespondend column. The counting will be done for pairs of 5 cells. (please see atachement)

An example of what I want to do is attached !!

http://www.sendspace.com/file/kh7sb4<!-- / message --><!-- attachments -->

 

[alinpion]

Any ideas on how to count is cell value is in the -5 : +5 range ;

I've tried =COUNTIF(data!A2:A6; {">=-5";"<5"}) but it doesn't work !!

 

[Aladin Akyurek]

Any ideas on how to count is cell value is in the -5 : +5 range ;

I've tried =COUNTIF(data!A2:A6; {">=-5";"<5"}) but it doesn't work !!

=SUM(COUNTIF(data!A2:A6; {">=-5";"<5"}))

is what you mean to have...

 

[alinpion]

=SUM(COUNTIF(data!A2:A6; {">=-5";"<5"}))

is what you mean to have...

I've solve that ; the formula was :
=COUNTIF(data!A2:A6; ">=-5")-COUNTIF(data!A2:A6; ">=5")

Now I need to know how to do this :

if formula is in B2 do COUNTIF(data!A2:A6; "=0") ; if formula is in B3 do COUNTIF(data!A7:A11; "=0") ; B4 A12:A16 and so on from 5 to 5 cells

I need a formula that will detect the cell in witch is placed and base on that it will determin the cells witch will be counted (ex: if formula in B2 then COUNTIF(data!A2:A6; "=0") like above)<!-- / message --><!-- edit note -->

 

[alinpion]

You know how this formula =COUNTIF(data!A2:A6; "=0") shold give a blank (" ") is all cells A2:A6 are blank

 

[arthurbr]

Cross post
http://www.excelforum.com/excel-pro...unting-from-different-sheets.html#post2561297