counting filtered rows ...
 

- you can sum a total of several rows : sum(e:e)
- but when I apply a filter I need the sum to be changed (counting only the
visible rows)

Any ideas,

Thanks,
Carl

counting filtered rows ...
 

Hi Charlie,

Try this:
=SUBTOTAL(9,E:E)

Regards,
KL

"Charlie" wrote in message
l...
- you can sum a total of several rows : sum(e:e)
- but when I apply a filter I need the sum to be changed (counting only
the visible rows)

Any ideas,

Thanks,
Carl

counting filtered rows ...
 

Thanks for your solution.

Charlie

"KL" schreef in bericht
...
Hi Charlie,

Try this:
=SUBTOTAL(9,E:E)

Regards,
KL

"Charlie" wrote in message
l...
- you can sum a total of several rows : sum(e:e)
- but when I apply a filter I need the sum to be changed (counting only
the visible rows)

Any ideas,

Thanks,
Carl