How to make 1 cell add the 7 before it??

[Mandy K.]

I am trying to make cell I add B, C, D, E, F, G, & H automatically... seems
easy enough but everything I try keeps giving me an error!!

Thanks for your help!!!!

[Duke Carey]

in cell I1 use the following

=SUM(B1:H1)



"Mandy K." wrote:

> I am trying to make cell I add B, C, D, E, F, G, & H automatically... seems
> easy enough but everything I try keeps giving me an error!!
>
> Thanks for your help!!!!

[CLR]

In cell I1, put this formula and copy down column I as far as you have data
in the other columns........

=SUM(B1:H1)

Vaya con Dios,
Chuck, CABGx3



"Mandy K." wrote:

> I am trying to make cell I add B, C, D, E, F, G, & H automatically... seems
> easy enough but everything I try keeps giving me an error!!
>
> Thanks for your help!!!!

[PAR]

Make sure all the cells are formated correctly. Are any formated as text?

"Mandy K." wrote:

> I am trying to make cell I add B, C, D, E, F, G, & H automatically... seems
> easy enough but everything I try keeps giving me an error!!
>
> Thanks for your help!!!!

[Mandy K.]

Thank you all for your help!!!!! :o)