I am working with two different a data about properties, and I am trying to count:
-the number of cells in an array in that match a given criteria
-and of those cells, how many match a criteria for a 2nd array in the data set
Array 1 (size):
70,000 | 52,000 | 60,000 | 30,000 | 75,000 | 25,000 | 19,000 | 45,000
Array 2 (expense/per square foot):
0 | .24 | .54 | .1 | 0 | .06 | .09 | .4
So from these two arrays, I would like to count all the cells in Array 1 that are between 50,000 and 100,000, but I only when them to be counted if their corresponding Expense/PSF (Array 2) is greater than 0.
So in this example both the 70,000 in the 1st column and the 75,000 in the 5th column would not be counted because they correspond to 0 expenses.
-the number of cells in an array in that match a given criteria
-and of those cells, how many match a criteria for a 2nd array in the data set
Array 1 (size):
70,000 | 52,000 | 60,000 | 30,000 | 75,000 | 25,000 | 19,000 | 45,000
Array 2 (expense/per square foot):
0 | .24 | .54 | .1 | 0 | .06 | .09 | .4
So from these two arrays, I would like to count all the cells in Array 1 that are between 50,000 and 100,000, but I only when them to be counted if their corresponding Expense/PSF (Array 2) is greater than 0.
So in this example both the 70,000 in the 1st column and the 75,000 in the 5th column would not be counted because they correspond to 0 expenses.
