- 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

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

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