For range filtering, you would need to use a date element.
I'm not sure what you are asking here. You are tlaking about automated sums but which can also be edited by hand ... but Fabrik doesn't have such a thing.
Is this related to your other question involving canEditRow?
As I said in my response on one of your other threads, in order to properly help you, it owuld be really useful to have an overview / specification of what your app needs to do, the workflow involved, the tables it needs, etc.
I'm beginning to get a sense of what you are trying to do, which is log and report on resource usage for properties 9like gas, water, electricity, etc). But we need to better understand what resource types you have, and the differences on how they are logged / summed / filtered, etc, so we can work out whether you can do this with a single generic "resource" table, or whether the resources need to be broken down in to different tables for each type, etc.
You will save yourself a lot of time in the longer term if you take some time now to get the project properly spec'ed, so we all understand what needs doing, and the best way of going about it, than rushing in to developing it "on the fly", without a clear understanding of how it all hangs together.
-- hugh