6 ms·
It looks like it's case sensitive. Worked for me with "=SUM(A5:A8)"
by dartf 8y ago
It looks like it's case sensitive. Worked for me with "=SUM(A5:A8)"
- y4mi 8y agoi was about to say the same thing... to anyone else wondering: you can browse the available function with the button to the right. ( SUM, AVERAGE, MIN, MAX and CONCAT )
- selimthegrim 8y agoWonder how much demand there will be for SUMPRODUCT
- codetrotter 8y agoFor anyone else wondering about that formula. https://exceljet.net/excel-functions/excel-sumproduct-function 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.