#VALUE

[MB]

I'm adding several cells from across two worksheets. I
get #VALUE with the following formula:

=SUM(JUNE!A3:E3)+(JUNE!I3:N3)+(JUNE!Q3:V3)+(JULY!A3:E3)

However, I get the correct sum with the following:
=SUM(JUNE!A3+JUNE!B3+JUNE!C3+JUNE!D3+JUNE!E3+JUNE!I3+JUNE!
J3...etc.

Why am I getting #value? I checked all cells and they
are formatted as a number with 1 decimal point. Many
cells are blank. Does this matter?

I tried F2 and then Ctrl+shift+enter, but it does not
give me a correct sum.

Help!

Thank you!!

 

[MB]

That did it! Thank you so much!

-----Original Message-----
Try,

=SUM(JUNE!A3:E3)+SUM(JUNE!I3:N3)+SUM(JUNE!Q3:V3) . . .
or even simpler
=SUM(JUNE!A3:E3,JUNE!I3:N3,JUNE!Q3:V3 . . . )

Dan E




.