[rattlsnak]

Who knows Excel? I have a workbook with two sheets. Sheet 1 has multiple rows ans two columns with their name in one and a certain value in the other column. (A1, A2, AA1, etc). On sheet two, I have the peoples names again and am trying to count the values off of sheet one and have them displayed on sheet 2. (like how many A1, A2, etc did this person receive on sheet 1).

I know how to make the formula to do this, but is there a faster way to simply "slide" the formula to all of the rows/columns? Every time I try to simply drag the formula to the next cell it is adding to the wrong value.

As an example, my formula for my cell that i want the data to go to is: =COUNTIF('Sheet 1 '!F:F,D1) but every time I drag it to the next cell down so it will auto populate, it will go to:
=COUNTIF('Form Responses '!F:F,D2) but i want to go to :
=COUNTIF('Form Responses '!H:H,D1)

and if I go to the next cell to the right, it will go:
=COUNTIF('Form Responses '!F:F,D2) and I want it to go to:
=COUNTIF('Form Responses '!F:F,E1)

So its counting up on the wrong value if that makes sense. Is there any way to make it continue on what it thinks is an inconsistent formula so I dont have to type out 1,000 of these??!!