Creating Calculations after Autofilter On

Y

Yunus

Hi,
I have autofiltered a Table.
The Cells filtered for example in Column C - C2, C3, C5, C8, C10, C12,
C14, C20, C21....

I want to do some calculations on the filtered cells automatically

e,g. In the above example How may I calculate the difference of 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
 
C

Cimjet

Hi
I'm not sure what you're trying to do but just use =C3-C2 and the same for the
rest. Hidden rows are not affected by that formula.
If I'm way off, would you explain it a bit more.
Cimjet
 
Y

Yunus

yunus786 said:
Hi,
I have autofiltered a Table.
The Cells filtered for example in Column C - C2, C3, C5, C8, C10, C12,
C14, C20, C21....

I want to do some calculations on the filtered cells automatically

e,g. In the above example How may I calculate the difference of 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

Hi

After Autofiltering you cannot use dragging or fill handle on the
visible cells.

So if the filtered cells in column C are c2, c4, c5, c7, c8, c9, c10

so if Column D I do a =C4-C2, then drag this down regardless of what
visible cells are displayed the series will follow C6-C4, C8-C6, C10-C8,
C12-C10 etc instead of C5-C4, C7-C5, C8-C7, C9-C8, C10-C9
 
Y

Yunus

Hi
I'm not sure what you're trying to do but just use =C3-C2 and the same for the
rest. Hidden rows are not affected by that formula.
If I'm way off, would you explain it a bit more.
Cimjet

Hi

After Autofiltering you cannot use dragging or fill handle on the
visible cells.

So if the filtered cells in column C are c2, c4, c5, c7, c8, c9, c10

so if Column D I do a =C4-C2, then drag this down regardless of what
visible cells are displayed the series will follow C6-C4, C8-C6, C10-C8,
C12-C10 etc instead of C5-C4, C7-C5, C8-C7, C9-C8, C10-C9
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top