Is this a homework assingment.

look in help index for COUNTIF

--
Don Guillett
SalesAid Software

"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