Dear Excel Expert
Please kindly help me to calculate the total number of directors of a list attached in the excel file. I would like to get the sum of column C in column I (total number of directors) for each company and for each year and in column J total number of independent directors for each company and each year.
I have manually put the sum for you to inform you what I want.
Please kindly help me.
Regards
Shams
You're very nearly there!
In I2, enter:
and copy down.Formula:
Please Login or Register to view this content.
In J2, enter:
and copy down.Formula:Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Dear Olly
Thank you very much for the help.
Regards
Shams
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks