Re-filtering Not Working/Do I Need a Table?

Dear Group:

I got a small data set of a client?s deposits for three months, and doing the calculations on the worked just fine without setting up a table.

But, I wanted to filter in on a particular type of transaction, in this case all the transactions that began with "ATM", and it threw off my calculations, as shown in the second sheet.

I was expecting that if I filtered the data, I was expecting the calculations in rows 76-80 to automatically display & recalculate.

It was a surprise to me when, the calculations disappeared.

I wanted to generate that report to send to the client to inquiry into these ATM transactions, but then I would have to re-create the calculations all over again, not what I expected.

I wanted to format and calculations (of rows 76-80) to remain the same when I filtered the data.

Is this is because I did not take the data and convert it into a table?
2023-06-16_3-22-26.jpg

Thanks for the quick response, but, I don't want to use the SUM Function, as I believe that if I change my filter parameters again the subtotal function is more appropriate.

Okay, I'll try using the "109" parameter as opposed to the regular "9".