Count in pair of 5 cells

[alinpion]

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")

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

 

[Andrew Poulsom]

Try:

=COUNTIF(OFFSET(data!A$1,((ROW(A1)-ROW(A$1))*5),0,5,1),"=0")

 

[alinpion]

Try:

=COUNTIF(OFFSET(data!A$1,((ROW(A1)-ROW(A$1))*5),0,5,1),"=0")

It works !!!

Thank you !!!!

 

[arthurbr]

Cross post http://www.excelforum.com/excel-programming/783823-count-in-pair-of-5-cells.html#post2561454