ok, you need to enter the = (not the one that is already on the top of excel, if you push that first equal sign it will allow you to use the built in formula wizard to modify the formula)
you can just copy and paste from above into the cell...
if you enter 4+3 into a cell, it will display "4+3"
if you enter =4+3 into a cell, it will display "7"
Autofill... you must enter all of the information into the first 2 rows (rows go across, columns up/down). After you enter manually the drawing info into the next blank cells in columns A3 thru C3 (draw#, Date, combo), you can simply click on D2 (ABOVE where you want the new info) then go to the last cell on the second row, press the SHIFT key and click it, it will then select cells D2 thru J2 (or L2 for pick4)
now, while they are selected, move the mouse into the lower right corner of the last selected cell until the pointer turns into a black plus sign ( + ) and move it one row down... this will not only copy all of the cell contents, but also update the formulas for that row.
IF you enter all of the drawing info first into columns A thru C, then you can autofill down from the 2nd row right to the last draw and do it all at once. You will still need to repeat this for each new draw added to the bottom of the sheet (mostly because I still can't figure out how to automatically grow ranges... we all need hints and tips every now and again ;-) )
hope that helps...
wish we had a small upload area then I could just post the sheet i have for PA midday (evening is too big) and you could just replace the results with those of your state.
good luck and keep working at it... excel is fun for it's own sake.