Subtotal filtered data at end of column.

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I have a spreadsheet used as a cheque register. Column D contains the
amounts and Column E contains the status of cheques. Column E can be sorted
to "blanks" to provide a list of outstanding cheques.

I want to run a macro that will automatically sort Column E and place a
formula in the last row of Column D that will sum the amount of outstanding
cheques. Apparently the SUBTOTAL function is what I need but can not get it
to input automatically in the last row and calculate.

Any help would be appreciated.

Thanks.
 
Hi
why don't you try SUMIF. e.g.
=SUMIF(E:E,"Outstanding",D:D)
to sum all outstanding amounts
 
Back
Top