What is faster, to refer to a cell via its address (in a different worksheet)
or via a name?

Also, how fast is the offset function?

I can do vlookup, sumif and sum with a range that has the limits determined
dynamically with the offset function or using large fixed ranges. Which one
is faster?

Thanks,

Antonio