Sum column dynamic range

[plk]

Hi al.. I need to sum the column in sheet2 and put it on a cell in sheet 1, i want to sum values in Column D, I gave =sum(sheet2!D2:D18) it dint work, i need to give dynamic range like D2:D lastrow. the samw i have to do for count function too. any help would be much appreciated..thansks

[dilipandey]

Hi Plk,

you can use a dynamic name which can then be used with sum function to obtain the desired result. Upload a sample workbook in case of any issues. thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>

[plk]

Hi Please check if it is fine. i just uploaded a sample workbook

[dilipandey]

Hi Plk,

See the attached file where I have used a dynamic name "data"... press Alt + I + N + D to see the name manager window and watch out for the name "data" to understand more.. thanks.

sample_forum.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[HSV]

Something like this.

=SUM(INDIRECT("Sheet2!D2:D"&COUNTA(Sheet2!D2:D1000)+1))

[plk]

Hi..Thanks to all it did work :-)

[dilipandey]

Cheers

Request you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>