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





Make the world a better place.

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

    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
    • Not Ranked
    • Posts 12
    • 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.

  • 10-07-2009 11:49 AM In reply to

    Re: Countif

    Wink Worked like a charm!

     Thanks again!

Page 1 of 1 (3 items)