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.
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,353
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.
 

Forum statistics

Threads
1,175,652
Messages
5,898,679
Members
434,722
Latest member
Jude_Beh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top