How to drag the total

[sachar]

Dear All,

With reference to the attach sample file, I dragged the total in “summary sheet” by manually. Can be possible to get the same with the help of any formula on the summary sheet?

Please help me, because I have huge data of the month.

 

[Asheesh]

Hi Sachar,

Use the below in B2 and drag it down

INDEX(INDIRECT("'"&A2&"'!K1:K100"),MAX(IF(INDIRECT("'"&A2&"'!K1:K100")<>"",ROW($K$1:$K$100))))

Change the ranges as per your requriement

Acknowledge with CTRL + SHIFT + ENTER..

Attached for ref.

 

[sachar]

Dear Asheesh,

Received with thanks, Please, what are the use of INDIRECT Formula, and "" here?

 

[Asheesh]

Great..!!

Red the below

http://spreadsheetpro.net/how-to-ma...a-worksheet-in-excel-and-google-spreadsheets/

https://www.ablebits.com/office-addins-blog/2015/02/10/excel-indirect-function/