Stuck on a simple formula

[mnpublic]

Hello,

I've multiplied using this formula ---> =SUM(B1*A2)/12 and got the result of 2.0 which is correct. However, when I try to copy down the formula this is what I get. 0.6 (in blue)is the result of the drag/copy down and the result should be 2.3. Each cell keeps referencing back to B1

You can see the image here. --> https://www.dropbox.com/s/k28sucqf1sxjtnu/Excel.png?dl=0

I've used excel for years and never had this kind of problem. I guess my brain is stuck. I'm not sure how to insert a worksheet here.

Thanks,

MN

 

[shg]

=b$1 * a2 / 12

 

[mnpublic]

Thank you so much! It works great.

 

[shg]

You might want to spend five minutes reading https://support.office.com/en-us/ar...ferences-dfec08cd-ae65-4f56-839e-5f0d8d0baca9