Hi, I'm looking for a little guidance with the following.
I need to write some code to count when a specified value is found in a range (column) and is = to a reference found in cell.
e.g. The column contains a range of values (C3:C6000) If the value between say >=30 but <=60 is found, then check the reference in same row but different column for the given reference, the count should only return true if this condition is achieved. The reference would be either Yes or No and the count would be returned in say AA3 = count if true and cell BB3 if count is false. True = Yes and False = No. Also the range (C3:C6000) could change C3 would not but the end value could. Iwould be very grateful if you could help me with this.
I need to write some code to count when a specified value is found in a range (column) and is = to a reference found in cell.
e.g. The column contains a range of values (C3:C6000) If the value between say >=30 but <=60 is found, then check the reference in same row but different column for the given reference, the count should only return true if this condition is achieved. The reference would be either Yes or No and the count would be returned in say AA3 = count if true and cell BB3 if count is false. True = Yes and False = No. Also the range (C3:C6000) could change C3 would not but the end value could. Iwould be very grateful if you could help me with this.