Hi, would appreciate some help with this.
Column B has the 'Sector Names'. I would like the number of times they appear in 'Sector' column M to be
shown under 'Number of these sectors' column C.
I would only require it to calculate the number of Sectors if the 'Status' cell shows 'Open' or 'Trade Open - Risk-Free'.
If anything else is shown in 'Status' then I won't require it to count the Sectors.
Thanks
Bookmarks