SUM of multiple cells (Ex. =SUM(T1:T6)+(T15)+(T24:T26)

It will not allow and giving error of #VALUE

Please help!

=SUM(T1:T6,T15,T24:T26)


On Jan 24, 3:04 pm, wrote:
SUM of multiple cells (Ex. =SUM(T1:T6)+(T15)+(T24:T26)

It will not allow and giving error of #VALUE

Please help!

On Jan 24, 3:13*pm, Jason Lepack wrote:
=SUM(T1:T6,T15,T24:T26)

On Jan 24, 3:04 pm, wrote:



SUM of multiple cells (Ex. =SUM(T1:T6)+(T15)+(T24:T26)

It will not allow and giving error of #VALUE

Please help!- Hide quoted text -

- Show quoted text -

Thanks, Jason. I am helping a co-worker and do not have the file. He
stated he tried that, but didn't work. He doesn't have time to check
at this time. I'll let you know how it goes. I am new at Google
Groups, but was told so many good things that I had to try. Thanks
for the help!

Try it like this:

=SUM(L21:N21,J35,R17:R22)


" wrote:

SUM of multiple cells (Ex. =SUM(T1:T6)+(T15)+(T24:T26)

It will not allow and giving error of #VALUE

Please help!

=SUM(T1:T6,T15,T24:T26)


Gord Dibben MS Excel MVP

On Thu, 24 Jan 2008 12:04:03 -0800 (PST),
wrote:

SUM of multiple cells (Ex. =SUM(T1:T6)+(T15)+(T24:T26)

It will not allow and giving error of #VALUE

Please help!