Forum Discussion

Copper Contributor

Apr 25, 2019

Special SUMIF function Not Working as Hoped

I'm trying to create a formula that will allow me to sum totals, based on another criteria in a table (so basically a SUMIF), but I only want to sum totals that are in the row or above the row, of th...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Apr 25, 2019

kaseyanne5 ,

For such table

it is

=SUMIF(INDEX([Username],1):[@Username],[@Username],[Value])

in Subtotal column

Subtotal in table.xlsx10 KB

kaseyanne5

Copper Contributor

Apr 25, 2019

SergeiBaklan Thank you so much!!