+ Reply to Thread
Results 1 to 1 of 1

Trying to write a Count If macro for a football qualit control sheet

  1. #1
    Registered User
    Join Date
    06-07-2010
    Location
    Michigan
    MS-Off Ver
    Excel 2016
    Posts
    47

    Trying to write a Count If macro for a football qualit control sheet

    I am trying to write a count if macro - at least I think it is a count if. In the attached worksheet, I want to know how many times I ran a play (column N) If the play made 4 yards (column O) it is an efficient play. I want a button that will run a macro and give me the following information: total all the plays in each group of column N (222 wedge, 330 power etc) then display something like this: 222 wedge - 10 plays out of 50 total plays = 20% 5 out of 10 plays efficient = 50 % 5 plays out of 50 total plays = 10% efficiency.

    Or something like that. Is there any help for me or am I asking for the moon and stars? I hope this is an easy fix. Thanks for any help you may be able to provide.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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