Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CountIf / SumProduct in VB
Hi All
What would be the best approach for the following scenario: So much to learn, such a large vacuum of space to fill, I still have so much to learn I need help constructing the correct syntax Sub TrafficFlow() Dim myRng As Range Set myRng = [F4:F300] If myRng.Value = #12:00:00 AM# And myRng.Value < #1:00:00 AM# Then Range("M5") = Count(myRng) End If If myRng.Value = #1:00:00 AM# And myRng.Value < #2:00:00 AM# Then Range("M6") = Count(myRng) End If ' ' 'down to If myRng.Value = #11:00:00 PM# And myRng.Value < #12:00:00 AM# Then Range("M28") = Count(myRng) End If End Sub As always thank you so much for your assistance. TIA Mick. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF, SUMPRODUCT, or something else | New Users to Excel | |||
sumproduct or countif | Excel Discussion (Misc queries) | |||
Countif - Sumproduct | Excel Worksheet Functions | |||
Countif or Sumproduct | Excel Worksheet Functions | |||
COUNTIF or SUMPRODUCT | Excel Discussion (Misc queries) |