Hi
I have a formula that Sums a range using OFFSET. This ensures that if a row is inserted immediately above the SUM then the value will be included. However, the OFFSET is volatile. Is there an alternative to OFFSET - can I use INDEX somehow?
Thanks for any ideas
Allister
Bookmarks