Hi there,
I have put together a drawing and want the worksheet to count nested symbols in a specific area of the drawing. I have named a rectangle area in the drawing "000-OrderArea", and they Symbol "ProjectSeat" appears in this area both on its own, as well as being nested within two other symbols.
Here is the formula in the Worksheet cell:
=COUNT((INSYMBOL & (S='ProjectSeat') & (LOC='000-OrderArea')))
The Worksheet is only counting the 'loose' symbols in the area, not any of the nested ones.
Any clues as to how I can get it to count ALL of the symbols in the area?
Cheers,
Nick