If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|