Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Additional criteria for a countif statement
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 '''an additional value which i dont know how to do '''''if it is either womans or mens golf shoes ''''i tried to embed an if it didnt work help!!! .. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting an additional formula in an IF statement | New Users to Excel | |||
COUNTIF with additional qualifiers? | Excel Worksheet Functions | |||
COUNTIF statement with 3 criteria checks | Excel Discussion (Misc queries) | |||
Can criteria in countif statement be a color? | Excel Worksheet Functions | |||
SUMIF/COUNTIF with an additional criteria | Excel Worksheet Functions |