hi!

i am having numbers in A1:E5 and want the totals in A6:E6

as under:

A1:E1 in A6,

A2:E2 in B6

A3:E3 in C6

A4:E4 in D6

A5:E5 in E6

hlp pl?

-via135

--

via135

------------------------------------------------------------------------

via135's Profile: http://www.yqcomputer.com/

View this thread: http://www.yqcomputer.com/

Just use the SUM function for whatever range you want. So, in A6 enter the

following formula:

=SUM(A1:E1)

And in cell B6 enter:

=SUM(A2:E2)

etc, etc...

HTH,

Elkar

following formula:

=SUM(A1:E1)

And in cell B6 enter:

=SUM(A2:E2)

etc, etc...

HTH,

Elkar

A6 should be =sum(A1:E1)

B6 should be =sum(A2:E2)

C6 should be =sum(A3:E3)

and so on and so on.

B6 should be =sum(A2:E2)

C6 should be =sum(A3:E3)

and so on and so on.

hi!

the thing is that i want the job done with using autofill from A6:E6

since i'm having numbers in more than 50 Columns??!!

-via135

ChuckF Wrote:

--

via135

------------------------------------------------------------------------

via135's Profile: http://www.yqcomputer.com/

View this thread: http://www.yqcomputer.com/

reminding for help!

-via135

hi!

the thing is that i want the job done with using autofill from A6:E6

since i'm having numbers in more than 50 Columns??!!

-via135

--

via135

------------------------------------------------------------------------

via135's Profile: http://www.yqcomputer.com/

View this thread: http://www.yqcomputer.com/

Say the first column is "A" and the last column is "AX" (giving 50

columns). The formula is:

=SUM(INDIRECT("A"&COLUMN()&":AX"&COLUMN()))

--

John James

------------------------------------------------------------------------

John James's Profile: http://www.yqcomputer.com/

View this thread: http://www.yqcomputer.com/

1. Random No generation rowwise

2. Total - Total Fields in a Totals Query

3. Report showing current total, previous total and average total?

4. Page total shows total for entire document not each section total.

5. Matrix Total Line till the end of the dynamic columns & Bold totals and sub-totals

6. Report totals Query Total Vs Table Total

7. Form Footer Total Does Not Always Total Correctly

8. Getting a total control to find totals for last 7 days via a q

9. Row Total (not column total) in Reports

10. Sub totals and grand totals on a form

11. Getting a total control to find totals for last 7 days via a query

13. Sub Totals and Totals in a report

7 post • Page:**1** of **1**