A running total with a growing range

Premium

In C2, start a running total that can be filled down to C7: SUM a range that starts at a locked $B$2 and ends at a relative B2.

C2
ABCDEF
1Month Sales Running total
2January 120
3February 95
4March 140
5April 110
6May 135
7June 150
8

Premium lesson

Unlock Relative and absolute references and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:PercentagesIF

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?