|
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
|