Calculation of named cell ranges
 

How do I keep the value of a subtotal calculation of a named cell range (i.e.
CASH is the named range of cells C1:C10)? When I change the auto filter to
another criterion (i.e. DEBIT), the value changes when I create another named
range to create a different calculation? I'd like to eliminate as much
manual entry as possible (if I were to filter for the respective category
each time, and then enter the subtotal in a different cell, then filter again
for a different category, and manually enter the subtotal in another cell).
Any thoughts?