Question: Monthly revenues of 2019 are entered in B2:M2, as shown below, To get year-to-date running total revenues, what formula should you enter in B3 and autofill through M3?

  1. `=SUMIF($B$2:$M$2,"COLUMN($B$2:$M$2)<=COLUMN())")`
  2. `=SUM($B2:B2)`
  3. `=SUM(OFFSET($A1,0,0,1,COLUMN()))`
  4. `=B2+B3`

Answer: The correct answer of the above question is Option B:`=SUM($B2:B2)`