CJ,

See if this will help. I added a helper column to each sheet (H) and used this, copied down...
=COUNTIF($F$2:F2,"<>")
This formula is added to each sheet under column H starting at row 2.

On the 2nd sheet, in H1...
=MAX(Alaska!H:H)
then use the COUNTIF formula
This is where I got lost as well.....

I am curious as well as to what FDibbins is alduring to as a solution.
I am always wanting to learn from these masters!!

Thanks