How to input criteria in spreadsheet row of worksheet

[Guest RMcK]

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. 

http://developer.vectorworks.net/index.php/VS:Function_Reference_Appendix#attrCrit

http://developer.vectorworks.net/index.php/VS:Search_Criteria#Search_Criteria_Format

http://app-help.vectorworks.net/2016/eng/VW2016_Guide/Worksheets/Worksheet_Functions.htm

 

Thanks!

[Pat Stanford]

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.