count if for more than one criteria
For several items listed in rows, I have one column with values "old" and
"new" . In each column in the array I have months from 01/2004 through
12/2014. I want to count values in the array that are more than 0.2 and "new"
in one row and more than 0.2 and "old" in a second row. The problem is that
count if only counts either more than 0.2 values or "old" or "new".
Any ideas?
|