Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jul 2007
    Location
    London, Gtr London, United Kingdom
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post Ratio calculation

    Hi

    The attached sheet shows open vs. closed tickets (white vs. red).

    How can I work out a ratio calculation?

    TIA

    BJ
    Attached Files Attached Files

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 646 Times in 590 Posts
    bj76
    Here is a peice of code that I placed in the Activate event subroutine of the Open Vs Closed worksheet. Everythime you open the sheet to view it, it will update with your percentages.

    HTH
    Maud


    Code:
    Private Sub Worksheet_Activate()
    For J = 4 To 37 Step 3
        Cells(J, 17).Value = ""
        Cells(J, 18).Value = ""
    Next J
    For H = 4 To 37 Step 3
        For I = 2 To 16
            If Cells(H, I).Interior.ColorIndex = 3 Then
                Cells(H, 17).Value = Cells(H, 17).Value + 1
            End If
            If Cells(H, I).Interior.ColorIndex = -4142 Then
                Cells(H, 18).Value = Cells(H, 18).Value + 1
            End If
        Next I
    Next H
    End Sub
    Attached Files Attached Files
    Last edited by Maudibe; 2012-12-29 at 11:02.

Posting Permissions

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