Thanks, works fine, if instead of 3 consequtive cells I need for 5 cells,
which of those "3" should be replaced by 5?
Thanks a lot.
Besr
Darius

"KL" wrote:

I assumed the number of cells in your range would be a multiple of 3 :-( Try
this:

=SUMPRODUCT(--(COUNTIF(OFFSET(E3:E94,(ROW(INDIRECT("1:"&INT(ROWS (E3:E94)/3)))-1)*3,,3),"0")=3))

KL


"Darius" wrote in message
...
thanks but the second equation (below)which I use for "E3:E94" and
contains
numbers, results in:
#REF
Any suggestion?
=SUMPRODUCT(--(COUNTIF(OFFSET(E3:E94,(ROW(INDIRECT("1:"&ROWS(E3: E94)/3))-1)*3,,3),"0")=3))

Best
Darius
"KL" wrote:

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