Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specifying a countif function within VB
I declared a range within a sheet of data which does the
countif function differentiates between multiple variables. It works great however, there is an additional factor in one of my variables that I want it to count only if that statement is true and not count if its not true. the statement is two columns to the left.. Thanks for your help in advance. ''''Code is as follows Dim IDSrng As Range Dim Fname As String Dim GS As String Fname = ActiveWorkbook.Name Range(Selection, Selection.End(xlDown)).Name = "IDSrng" GS = "=COUNTIF(" & "'" & Fname & "'!IDSrng,""Golf Shoes"")" ActiveWindow.ActivateNext ActiveCell.Offset(1, 0).Select ActiveCell.FormulaR1C1 = FOB ''''''''''Here i need to specify to the left 2 columns '' ''''(activecell.offset(0,-2).select) '''''if it is either womans or mens golf shoes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF Function | Excel Worksheet Functions | |||
please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
countif function | Excel Worksheet Functions |