Use Case: I have multiple financial portfolios that cannot be connected to via API. I want to track my total balance across portfolios. I do not want to tally every portfolio every day - instead, I want to update individual portfolios occasionally, and have a running "up-to-date total"

enter image description here

This would be easy if Google Sheets had a REDUCE function. Here's what I've tried:


I've also tried removing SUM and trying to just print the last values of each column using ArrayFormula. I have also tried using =ArrayFormula(LOOKUP(2,1/(B3:D>0),B3:D)) as an alternative to get the last value of each column.

  1. How can I calculate the sum of last value across multiple columns?
  2. Why does GSheets not have a REDUCE function?
  • Hi." Why does GSheets not have a REDUCE function?" That is really a question that you ought to direct to Google through the Sheets Help Menu "Help Sheets improve".
    – Tedinoz
    Sep 8 '21 at 2:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.