Jump to content

Hitting a wall with Worksheet calculations in Spotlight. Need help from the hive-mind

Recommended Posts

I don’t have much experience with spreadsheets, but I’m trying to make something that I need, and learn from it.

I am trying to make a template worksheet for risers and legs.

Using Spotlight’s Stage Deck tool, I have already made a worksheet that list all instances of every riser by size (4’ x 8’, 4’ x 4’, etc) with how many legs for each riser by length (3’0”, 2’6”, etc)

I have made a cel calculation that gives me the total of all risers in the worksheet.

What i want to do now, is make a cel calculation within this existing worksheet that would let me break down how many of each item is in the worksheet  (how many 4’ x 8’, how many 4’ x 4’, etc.), and also do the same for leg lengths


I’m been racking my brain for days trying to make cel calculations that do this, and I'm stumped. I guess what i need is the following:


— Find a specific name in entire column, then place that name into the cel


— Find every instance of a specific item in entire column, then place total about of those instances of those found items into the cel


Can anyone here help me with this? I hope I’m not asking too much.

Share this post

Link to post

Woo! I totally solved it using this kbase! Thanks to this, it was easier than I thought.



Edited by JHLD
added a comment

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114


© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.