Sum each row with based on Col A of Data Sheet

Originally Posted by rorya

Glenn,
Why UNIQUE(INDEX(A,SEQUENCE(ROWS(A)),{1,2})) rather than just UNIQUE(A) out of interest?

No coffee yet.

Actually A originally referred to columns A:G. I changed its definition, but didn't change the unique bit correspondingly. Again, caused by no coffee.

Originally Posted by Glenn Kennedy

No coffee yet.

Actually A originally referred to columns A:G.

I figured it would be something like that (on both counts), but wanted to check I wasn't missing something. Thanks.