2010 FORM Count and Filter

Formula for the Form Total Cell

=Sum(IIf([COLUMN]=520,1,0))

Meaning

520 is the item to be filtered (Filters anything that has 520)

1 True (This counts the 520 items)

0 False (This does not count everything else)