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?
- `=SUMIF($B$2:$M$2,"COLUMN($B$2:$M$2)<=COLUMN())")`
- `=SUM($B2:B2)`
- `=SUM(OFFSET($A1,0,0,1,COLUMN()))`
- `=B2+B3`
Answer: The correct answer of the above question is Option B:`=SUM($B2:B2)`