Just change your calculation to:
Well that part doesn't include the category of just a certain type from a column. Also, why does it work when I do this. It has no problem doing this.
This one is correct as it is not aggregated. For your previous question, I corrected the formula you can extend it using ELSEIF THEN.