Re:Show HN: X-spreadsheet – A JavaScript canvas spreadsheet ...
by selimthegrim on Monday January 28, 2019 @12:34PM
(#19019294)
Wonder how much demand there will be for SUMPRODUCT
Re:Show HN: X-spreadsheet – A JavaScript canvas spreadsheet ...
by codetrotter on Monday January 28, 2019 @06:54PM
(#19022349)
For anyone else wondering about that formula.
https://exceljet.net/excel-functions/excel-sumproduct-functi...
All I can say is, I am grateful I don’t have to deal with other people’s spreadsheets.
My jam is programming languages and SQL, not obscure formulas and weird constructs made from surprising ways of using them.
to anyone else wondering: you can browse the available function with the button to the right. ( SUM, AVERAGE, MIN, MAX and CONCAT )