| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count using IF / AND
If cell B3 is between a number range and another cell in same Row =(Z) count.
As cells are populated the count will increase. So the cell must be between 10 and 20 and the second cell must =Z to count as 1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count using IF / AND
RERAA wrote:
If cell B3 is between a number range and another cell in same Row =(Z) count. As cells are populated the count will increase. So the cell must be between 10 and 20 and the second cell must =Z to count as 1 http://www.contextures.com/xlFunctio...tml#SumProduct |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count using IF / AND
'IF' you gave a clearer explanation 'AND' gave some examples we may be able
to help you 'count' "If cell B3 is between a number range" What is the number range? "another cell in same Row =(Z) count" Count what? "As cells are populated" What cells? "So the cell must be between 10 and 20" Why? "and the second cell" What second cell? "the second cell must =Z to count a 1" What is the logic here? I sure you must know what you mean but I'm not so sure anyone else will !!! "RERAA" wrote: If cell B3 is between a number range and another cell in same Row =(Z) count. As cells are populated the count will increase. So the cell must be between 10 and 20 and the second cell must =Z to count as 1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Hybrid Mode
