This article details how to have a SUM of values with filters (ex. any amounts over 5,000,000)
Use the SUMIF Excel statement with the greater than (>) symbol. Be sure to add quotes around the calculation. For an expanding group, expand the range one row beyond the group so that it expands.