W wop0703 Registered User. Local time Today, 10:53 Joined Jun 1, 2005 Messages 77 Jun 9, 2005 #1 I want to sum together the number of check boxes checked. The problem is that Sum gives a negative number. What shuold I do?
I want to sum together the number of check boxes checked. The problem is that Sum gives a negative number. What shuold I do?
J Jon K Registered User. Local time Today, 15:53 Joined May 22, 2002 Messages 2,209 Jun 9, 2005 #2 -Sum(...) or Abs(Sum(...)) .
neileg AWF VIP Local time Today, 15:53 Joined Dec 4, 2002 Messages 5,970 Jun 10, 2005 #3 Just as a bit of background: The value of Yes is stored as -1 and No is stored as 0. If you sum the checkboxes you will always get a negative number (or 0).
Just as a bit of background: The value of Yes is stored as -1 and No is stored as 0. If you sum the checkboxes you will always get a negative number (or 0).
