I have a CRM subform with an aggregate sum at the bottom called 'Total Units'  I want it to exclude units from the sum if they are of a particular type and show these on another aggregate sum.  I can't fathom how to do this. 

Within the aggregate field section, it has a formula option...... but SUM isn't one of the functions and the subform fields don't seem to be available to choose.