Replace the colons with commas:

=SUM(G6,H6,I6,J6,L6)*.175



"Timeferret" wrote:


Is there a better way to write this formula?

=SUM(G6:H6:I6:J6:L6)*17.5%

I noticed writing it this way, F6 is automatically added to the sum.

Thank you


--
Timeferret
------------------------------------------------------------------------
Timeferret's Profile: http://www.excelforum.com/member.php...o&userid=19170
View this thread: http://www.excelforum.com/showthread...hreadid=571823