Welcome to Forums Sign in | Join | Help | Forums
in Search


Countif

Last post 10-07-2009 11:49 AM by Bryce Katzman. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 10-06-2009 3:55 PM

    • Bryce Katzman
    • Top 200 Contributor
    • Posts 43
    • Organization: Farm Sanctuary
    • Products:  The Raiser's Edge

    Countif

    I have a column {@IF} that is based on a formula. It produces the following

    CnBiosName                   (formula created column) 

    John                                Not Paid

    Paul                                Paid

    Ringo                              Paid

    Ben Rothlisberger             Paid

    George                            Paid

    I would like a count of how many "Paids" and "Not Paids"

     

    Thanks so very much!

    Bryce

  • 10-06-2009 4:42 PM In reply to

    • Patrick Manning
    • Top 200 Contributor
    • User Since: 1997
    • Posts 45
    • Organization: College of Charleston
    • Products:  The Raiser's Edge

    Re: Countif

    I suppose you could use a RunningTotal or a variable but the easiest way would be to create a formula for each of those values:

    Formula:  If {@if } = "Paid" then 1

    Insert that formula and total it.  Do the same for the "Not Paid" people.

    Patrick Manning
    Database Administrator
    Advancement Services
    College of Charleston
  • 10-07-2009 11:49 AM In reply to

    • Bryce Katzman
    • Top 200 Contributor
    • Posts 43
    • Organization: Farm Sanctuary
    • Products:  The Raiser's Edge

    Re: Countif

    Wink Worked like a charm!

     Thanks again!

Page 1 of 1 (3 items)