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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,303
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,141,022
Messages
5,703,788
Members
421,316
Latest member
Cyril Beki

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