Tuesday, May 11, 2010

A client introduced me to this approach

It's quite useful to do SUM with multiple criteria in reference to: Excel SUMPRODUCT formula - Syntax, Usage, Examples and Tutorial | Chandoo.org - Learn Microsoft Excel Online (view on Google Sidewiki)

Updated: 21st July 2010

Criteria driven results can also be arrived through use of Array Formulae. Mr. Excel writes about this on his CSE (Control+Shift+Enter) article.

No comments: