ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   in excel just want to add 4 columns and total in next column (https://www.excelbanter.com/excel-worksheet-functions/21240-excel-just-want-add-4-columns-total-next-column.html)

michael_l

in excel just want to add 4 columns and total in next column
 
never used excell-just want to add D2+E2+F2+G2+H2 and show total in I2

JE McGimpsey

One way:

Enter this in I2:

=D2+E2+F2+G2+H2

another way:

=SUM(D2:H2)

In article ,
michael_l wrote:

never used excell-just want to add D2+E2+F2+G2+H2 and show total in I2


CLR

In cell I2, type

=SUM(D2:H2)
or
=D2+E2+F2+G2+H2

Either should give you the sum you want........

Vaya con Dios,
Chuck, CABGx3



"michael_l" wrote in message
...
never used excell-just want to add D2+E2+F2+G2+H2 and show total in I2




Kassie

In I2 enter the following: =SUM(D2:H2)

"michael_l" wrote:

never used excell-just want to add D2+E2+F2+G2+H2 and show total in I2



All times are GMT +1. The time now is 05:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com