VBA Code I just cannot get it.

Stuzzz

New Member
Joined
Sep 24, 2006
Messages
3
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.
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,915
Office Version
  1. 365
Platform
  1. Windows
Do you really need code for this?

Sounds to me like you could use a worksheet function(s), perhaps SUMPRODUCT.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,986
Messages
5,545,347
Members
410,679
Latest member
rolandbianco
Top