We help IT Professionals succeed at work.

having an issue with a calculation

what is wrong with this equation?
=SUM((C4+(C61:C65)+(C100:C104))*data!B16)
Comment
Watch Question

You can't break up the Sum function like that. Try this: 

=(SUM(C61:C65)+SUM(C100:C104)+C4)*data!B16

Paul

Actually, you can combine the Sum range with a comma:

=(SUM(C61:C65,C100:C104)+C4)*data!B16

Sorry, forgot to check my work. All the cell can be covered in the Sum function:

=SUM(C61:C65,C100:C104,C4)*data!B16
Be careful when you use + and ranges in the sum function.
It will be treated as an array.
SUM(C4+(C61:C65)+(C100:C104)) is calculated like this (C4+C61+C100) + (C4+C62+C101) + … + (C4+C65+C104)
That is not the same as SUM(C4,C61:C65,C100:C104) = C4+SUM(C61:C65)+SUM(C100:C104)
Matt PinkstonEnterprise Architect

Author

Commented:
Thanks