Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count If Range?
Hi All
Having a hard time with the following Private Sub Add1_Click() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("Customers") Worksheets("Customers").Select Tb1.Value = Application.CountIf(Range("J3:J600"), "35") <<<< Working ok What I need is Tb1.Value = Application.CountIf(Range("J3:J600") ' ws("Prices") Range ("A2") so that if I change the price from "35" to 40 in ("A2")("Prices") it will count the "40" in the "Customers" sheet. Is this possible please - over 2 hours down the line and still no further forward. -- Many thanks hazel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Vaules in a range that appear in another range | Excel Worksheet Functions | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
count with a range | Excel Programming | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions |