Excel Error #N/A

I am doing a course in excel and is following the instructions to a T.  But after as instuckted to put $ signs in the selector cell bar and drag it down.  It gives me errors.   I am trying to add t...