help with adding rows

[DaleL]

Im using http://www.rondebruin.nl/mail/folder3/row.htm.
To mail all the rows on sheet1 row by row. I need to add all th
numbers in each row before it is sent,
so the the numbers in the row are all sent and the last cell is th
total some thing like this

test1 test2 test3 test4 test5 test6 Sum
1 1 1 1 1 1 6

There is 14 test total so it will be a lot longer line then this als
im looking to add a msg to the end depending on the out come of the su

94 to 100 you got an A ....congrats
87 to 93 you got a B ....good work
81 to 92 you got a C .... maybe you need to come see me after class

some thing like that.. i was looking at using sum of cells G1 threw T
but do i need to go thre every row and add the formula to every row ??

Dale

 

[Ron de Bruin]

but do i need to go thre every row and add the formula to every row

Yes : In the last column add a formula like this
=IF(SUM(G1:T1)>=94,"A",IF(SUM(G1:T1)>=87,"B","C"))
copy this formula down till the last row

 

[Ron de Bruin]

Another way is this
http://www.cpearson.com/excel/excelF.htm#Grades

--
Regards Ron de Bruin
http://www.rondebruin.nl

Yes : In the last column add a formula like this
=IF(SUM(G1:T1)>=94,"A",IF(SUM(G1:T1)>=87,"B","C"))
copy this formula down till the last row

 

[DaleL]

I guess im just thick headed.. but i have copied and pasted and bee
threw help files for how to add this formula but i cant get it to wor
correctly.
All i need is a sheet that will add all the rows G threw T and put th
total in U and a letter grade in V for some reason this just seems t
be beyond me to make it work.

Dale

*Another way is this
http://www.cpearson.com/excel/excelF.htm#Grades

--
Regards Ron de Bruin
http://www.rondebruin.nl

 

[Ron de Bruin]

Hi

In U1 : =SUM(G1:T1)
in V1 : =IF(U1>=94,"A",IF(U1>=87,"B","C"))

Select U1:V1 and copy down till the last row

 

[DaleL]

Thanks Ron this has gotten me one more step closer to the end thanks ma

Dal