Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel formula
sorry threr is some mistake in the macro I have given . ignore the message
"R..VENKATARAMAN" wrote in message news:... try this though inelegant macro Public Sub test() Dim i As Integer i = 0 Dim myrange As Range Dim c As Range Set myrange = Range(Range("a1"), Range("a1").End(xlDown)) For Each c In myrange If c = "FAC" And c.Offset(0, 1) = "1" _ And c.Offset(0, 2) = "SL" _ Then i = i + 1 Next For Each c In myrange If c.Offset(0, 2) = "SL" Then i = i + 1 Next MsgBox i End Sub "jaypee" wrote in message ... good day! i need a excel formula that counts FAC, 1,SL or VL as 1. FAC 1 SL FAC 1 SL FAC 2 SL FAC 1 VL FIS 1 VL in this sample the formula must count 3.. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |