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.

## 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. |

Updated: 5/9/12