Forum Discussion

kaseyanne5's avatar
kaseyanne5
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 the current cell.

 

I tried this:
=SUMIF([Username],[@Username],G$2:G2)

 

I'd hoped this would help, as with each row the end point of the range would change. But, when I use this function, it still sums the entire column G based on the criteria, not just from that range. A normal SUM function works the way it should, but SUMIF is summing the whole column.

8 Replies

Resources