Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linked cells show wrong number | Links and Linking in Excel | |||
Find all cells with a number and mulitply | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
only include cells beginning with specified character or number | Excel Worksheet Functions |