Results 1 to 12 of 12

indentify status text in ne colum and count in another if

Threaded View

  1. #1
    Registered User
    Join Date
    04-18-2012
    Location
    Cph, DK
    MS-Off Ver
    Excel 2010
    Posts
    14

    indentify status text in ne colum and count in another if

    Hi!

    I know next to nothing about vb programming, but nevertheless i have tried to compile a function it although contains an error which i can't identify.

    Function Countcoloriftext(varRange As Range, subRange As Range, statustext As String, subText As String)
    Dim cell As Range
    Application.Volatile
    For Each cell In varRange
        If cell.Text = statustext Then
        For Each cell In subRange
        If cell.Text = strText Then
    Countcolorif = Countcolorif + 1
    End If
    End If
    Next
    End Function
    Hope someone can and will help... thx
    Last edited by Slowfish; 04-23-2012 at 09:42 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1