Jump to content

How to input criteria in spreadsheet row of worksheet

Recommended Posts

I am trying to create a worksheet with multiple formulas in it. For this I need to be able to search different criteria in each column. The type is spaces. What is the order of the text I need to input into the cell to pick up with the criteria would do in a database row? I have looked through all of the following places and it is not very clear to a novice. 






Share this post

Link to post

Most of the worksheet functions can take criteria as a parameter when they are in worksheet cells even though they don't need criteria when in a database header.


=AREA in a database header might become  =Area(((L='1-Floor') & (C='Red'))) when in a worksheet cell.


Tell us more about what you are doing. Especially why you don't want to use a database and we might be able to give you better suggestions.

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.