4 ms·

It's a little known fact (is it?) that there are database functions in Excel! You can calculate simple aggregates like count and sum of records subject to some

It's a little known fact (is it?) that there are database functions in Excel! You can calculate simple aggregates like count and sum of records subject to some constraints. Example: https://support.office.com/en-us/article/DAVERAGE-function-a6a2d5ac-4b4b-48cd-a1d8-7b37834e5aee https://support.office.com/en-us/article/DAVERAGE-function-a... These functions were available since Excel 2.0 but many people don't know they exist

infogulch 10y ago
Excel's filtering syntax (e.g. SUMIF) and this function are obtuse, difficult to use, and very simplistic just compared to a WHERE clause on a sql statement. And this ignores other very powerful sql features like pivot and group by that are exceedingly difficult for excel to produce.
- falsedan 10y ago
  You just described pivot tables, which are well-supported by Excel and Google Sheets.
- garyclarke27 10y ago
  Sumifs and countifs are far more powerful (see my other comment) I no longer use d functions since these where added in office 2013
codezero 10y ago
High five to you for adopting (did you?) my (is it?) quasi-half-assertion.