I have a list of names (it's an Exchange GAL extract), and I'm trying to
count all the names that fall between a range of letters, i.e. 'A-F', 'G-L',
'M-R', S-Z'.

Right now, I've added a column to the extract page that uses a conditional
IF to populate some text into the cell that reflects which range the First
letter of the Lastname falls in. This is then filled down the column until I
hit the last populated row:

=IF(LEFT('sheet2'!D2,1)<='sheet1'!$C$5, "SG1",
IF(AND(LEFT('sheet2'!D2,1)='sheet1'!$A$6,LEFT('sh eet2'!D2,1)<='sheet1'!$C$6), "SG2" ...(and so on)

I then do a set of simple =countif('sheet2'!A:A,"SG1") to get the totals.
This does work, but is dependant on the manual process of dragging the IF
formula down the set of records.

There has to be an easier way to bypass the manual IF step and do the
CountIF across any list of rows, but I can't figure out how to get the
criteria in properly.

Thanks in advance,

Chris.