ExcelBanter - Calculations of Cell after Autofiltering

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Calculations of Cell after Autofiltering (https://www.excelbanter.com/excel-worksheet-functions/419722-calculations-cell-after-autofiltering.html)

Yunus Patel

Calculations of Cell after Autofiltering

Hi,
I have autofiltered a Table. The Cells filtered e,g C2, C3, C5, C8,
C10, C12, C13, C14, C20, C21....

How may I calculate the diffrenec in values of successive cells i.e C3-
C2, C5-C3, C8-C5, C10-C8, C12-C10 etc

SUBTOTAL(9, C3,C2) only sums the cells.
SUBTOTAL(9, C3,-C2) does not work

I attempted using SUBTOTAL(9, C3-C2) but this does not work

All times are GMT +1. The time now is 07:47 AM.