4 ms·
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. An
by 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 agoYou just described pivot tables, which are well-supported by Excel and Google Sheets.
- garyclarke27 10y agoSumifs and countifs are far more powerful (see my other comment) I no longer use d functions since these where added in office 2013