Copy expanding ranges into complete running totals
Your goal: Keep the first source row fixed, move the endpoint with each entry and copy the same seed across two signed measures.
Full task requirements
Enter one formula in G2 and use actual formula copying or filling to build G2:H7. G contains the cumulative Net amount and H the cumulative Signed units, including the current physical source row. Keep source order and include every signed value and numeric zero. All twelve outputs need individual native copies of your G2 seed; a one-anchor SCAN spill is a different learning exercise. Use finite whole-cent numeric measures from -1,000,000 through 1,000,000. Labels, including duplicates and literal punctuation, do not group or sort records.
=SUM(B$2:B2)| # | ||
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 |
Grow the first prefix
Select the complete inclusive source prefix for this destination. Its starting row stays fixed, its endpoint follows the destination row, and copying right changes the measure column. A zero or refund still belongs to the prefix.
- Copy from
- G2
- Copy to
- G3
=SUM(B$2:B2)
Select the source inputs in the worksheet
Choose every input read by the formula after copying to G3. Use Cells for separate inputs or Range for a complete prefix.