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.

 

[Fluff]

Duplicate to: Taking Sumif total on individual sheets using one column

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.