Re: SUM of certain cells after Autofilter

Hi Roger

The problem is to consider a criteria ("2") in addition to the filter (marking for a certain department).

For better understanding: the sum is required for 1, 2, 3,... On the basis of these results, a diagramm will be built.

There is little opportunity to reorganize the *** or to create separate areas for assistance because it's not "my" work***.

Bernd

Roger Govier schrieb:

Hi Bernd

Where are you putting the SUBTOTAL formula? Is it within the range of data and therefore possibly getting confused?
Try inserting a row above your first row and putting the formula there.
=SUBTOTAL(9,C2:C1000)
adjhust range to suit

Bernd wrote:

Hallo,

The following work*** (as an excerpt of a bigger one) is to be analysed:
x x 2
x 1
x 2
2

After Autofilter regarding x in any column the sum of VISIBLE cells with the value 2 should be calculated (e.g. 2 for the first column and 4 for the second one). The function SUBTOTAL seems not to give a proper result considering conditions). Any idea?

Regards

Bernd


.