Calculation for totaling information in one field
Not sure how to ask this question, but I have a database that in one layout, there are four main fields, but they have much data associated with them. What I'm trying to do is group certain departments together so their area numbers total together. The image provided shows to different views, one is what the fields are in layout mode and the other one, I've circled an example, of the 3 areas that I would like to total together. What's the best way to do a calculation for this that hopefully, I can use for other groupings? Or what's the best way this should be done? Any help is greatly appreciated. Thanks.