Useful Excel Functions
Resources

Excel is an extraordinarily versatile tool. The functions described below are a very small subset of the many available. They're shown here because they've been found helfpul in AE projects, particularly those in AE-Design. You'll find them explained in detail with examplesin the Excel Workbook that's linked below. The table here lists the tools that are in the workbook.

The Excel help functions are very useful. Once you know that the function exists I urge you to look for detailed information with the help function.

AE EXCEL TOOLS

Tool

Workbook Tab

Description

Comment

SumProduct

Criteria Matrix Tools
Multiplies each row of table together and then sums the product of that. Very useful for getting totals in Criteria Matrices

If Function

Criteria Matrix Tools
Puts different values in a cell depending on "conditions" that are evaluated. Very helpful for putting different values in a criteria matrix given different general conditions such as building size or location.

Choose Function

Criteria Matrix Tools
Puts different values in a cell depending on "conditions" that are evaluated. Very helpful for putting different values in a criteria matrix given different general conditions such as building size or location. Easier to use than IF function when have multiple choices.

Drop-Down via Combo Box

Selection
Puts a number (1 to n) in a cell where n is the number of possible choices. Very helpful for having a user choose between different options.

Radio Button Selection

Selection
Like "Drop-Down", but uses radio buttons. Very helpful for having a user choose between a small number different options.

Autofilter

Lists
Turn an organized "table" of data into a simple database from which you can easily select similar values Very helpful in such projects as developing a building program.

Subtotal Function

Lists
Shows the total of only visible rows of a table that has been filtered via autofilter. Like the "sum" function, but provides sums for only those rows that are selected via the filter. Also has multiple possible functions such as count, average etc.

Return to Top

Updated: 5/9/12