>I don't think there is much you can do there - the autosum is is supposed to detect a contiguous range of cells. You can, however, always enter formulae in the old-fashioned way, i.e., manually entering the desired range.

Yes, that is what I told the client yesterday but it wasn't much that accepted. Users are used to go automated with that. Now that we no longer show zero values on certain cells, which made the reports much more easy to read and manipulate, we might have to retro back that change because of this autosum users are doing.