**Need help with this darn excel**
I'm in a fantasy baseball league and I want to see how many pts my team would end up with if they repeated last years numbers, also want to tweak some numbers to my projections and such, so I figured excel would be awesome instead of busting out the ol calculator.
I can't seem to figure out how to get a formula to make each category work tho! What I did was I listed all my players on the left side going down, and then listed the categories going across on top. I filled in the numbers for a couple players, and I tried to modify the categories as approriate. Example, a HR is worth a total of 5 pts, so I entered 5 under the category HR, clicked =, clicked the 5, then typed in how many homers my player hit in the approriate box. But when I go and drag the formula down, it changes and does not stay constant with the cell that the 5 is in, rather goes down to the next cell, and then the next, etc...
I want to make it so a whole column has a formula for it, like 5 * X number of HRs, then the next column have 3 * X number of triples my player has, so on and so forth.
Thanks for listening to what was probably a hella confusing post lol