Forum Discussion

Copper Contributor

Aug 10, 2022

Solved

Sum values across ROWS in LookUp

I have what should be an easy question...and yet... Let's say I have a data table as follows: Jan 56 Feb 92 Mar 48 Apr 87 May 66 Jun 99 Jul 78 Aug 83 Sep 6...

Formulas and Functions

dscheikey
Aug 10, 2022
Hi PRisman,
You can do this with MATCH(), OFFSET() and SUM(). See the example file attached.

In January and February that it doesn't work.
Sum values across ROWS in LookUp.xlsx9 KB

dscheikey

Bronze Contributor

Aug 10, 2022

Hi PRisman,

You can do this with MATCH(), OFFSET() and SUM(). See the example file attached.

In January and February that it doesn't work.

Sum values across ROWS in LookUp.xlsx9 KB

PRisman
Copper Contributor
Aug 10, 2022
whoa....... i would never have gotten there on my own... THANK YOU!!