My sheet has 3 columns (Team, Activity, Amount). I have a summary section at the top of my sheet where I want to use a SUMIF function to total up the amount for each Team.
Generally, I can get the SUMIF function to work just fine. But, I run into an issue when adding new rows.
The function looks