Hi again,

For task 2 try the following:

=SUMPRODUCT(--(COUNTIF(OFFSET(A1:A10,(ROW(INDIRECT("1:"&ROWS(A1: A10)/3))-1)*3,,3),"0")=3))

Reagards,
KL


"KL" wrote in message
...
Hi Darius,

For the first task use the following formula:

=COUNTIF(A1:A10,"0")

Regards,
KL

"Darius" wrote in message
...
Hi there;
1-What is the equation to find the number of cells in a range which their
values are more than 0.0?

2- How to count the number of cells in range which for every 3
consqueative
cells are non 0.0, I mean if cells 1, 2, and 3 are more than 0.0, then
count
= 1 then next 3 cells, ... and if one 3 consequative cells have (even one
cell) a 0.0 value then that 3 cells donot add to our count number?

Appreciate any help.
Best
Darius