a little unclear but

=sumproduct((sheet2!a1:a100=1)*(sheet2!a1:a100<=1 0)*(sheet2!b1:b100=1))

will return a count of the # of 1's in column b sheet 2 where column a
is in the range of 1 to 10

If you are trying to refer to the column a entry in sheet 1 of "1 -
10", I think you will have difficulty, though you could neter 1 in say
column f and 10 in column g and refer to those cells in the sum product
(instead of "=1" use "=f2" if the 1-10 row is row 2. The column a
entry would then be =f2&" - "&g2

hope this helps


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=382197