Taking Sumif total on individual sheets using one column

[Harjeetsingh]

Hi,
I have a holding report having total of around 5000 rows having various securities and at least 50 clients holding those securities most of them are cross held.
Now i am preparing a report having trader wise worksheets and list of securities held by them. Worksheet name is client short code. How can i use sumif formula in each trader sheet taking sum total security wise from that one holding report. Cli

 

[GlennUK]

You want to do a SUMIF of one holding report, based on the name of the current sheet? if so, this will help:

To create a formula to get the worksheet name we need to use CELLS, FIND, and MID function. Following is the function where you can get the sheet name.

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename")))