AnsweredAssumed Answered

COUNT IF

Question asked by rjserrano on May 10, 2011
Latest reply on May 10, 2011 by rjserrano

Title

COUNT IF

Post

I've been searching for help on this and am not really liking anything I'm seeing...There's got to be an easier way???  I have a field made up of about 7 unique values.  I want to set up 7 different (new) fields...each one would return a count of the number of each unique value...the field is an attendance type field.  It is a description of a reason for an absence...i.e. illness, dr. appt., etc.  I want to set up another field(s)...one that will calculate how many were due to "illness"...another field that will calculate how many due to "dr. appt.", etc...A COUNT IF (for those who've worked with Excel) type function...Please, someone give me an easy way to accomplish this task?!  Thanks!

Randy

Outcomes