How to calculate MTD and YTD Variance

[jkang22]

I have a set of Months Actual and Months Budget. I'd like to calculate the MTD and YTD variance in a specific cell. For the MTD variance, i'd like for it to calculate the month in which we are presently in.

ive copied the spreadsheet below... PLEASE HELP!

8/1/2012 FY13 Budget FY 13 Actual JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN MTD Variance YTD Variance 50 50 150 100 200 50 50 50 75 85 60 90 40 60 <colgroup><col><col span="25"><col><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[jkang22]

no i tdid not work, its popping up as #N/A

 

[texasalynn]

make sure you have the correct cell ranges in the formula