Hi,
in this particular instance, this formula will do the trick (I've deleted the enclosing round brackets from C3!!!)
.... but I'm wondering if there is not a bigger picture that, upon understanding and analysing, may make the whole concept a bit easier.
Why don't you step back a few paces and tell us what this is all about? It looks like some kind of accounting application, where you want to sum certain cells, but you want to be able to determine on a case by case basis which cells/account codes are to be summed?
Is that about right?
Bookmarks