You can't break up the Sum function like that. Try this:
Actually, you can combine the Sum range with a comma:
Sorry, forgot to check my work. All the cell can be covered in the Sum function:
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.