Hi,
try

=SUMPRODUCT(--(Sheet2!F1:F100),--(Sheet2!F1:F10<=30))

change range to fit your needs

"Heather" wrote:

I have and age Field and a Column that contain counts.
If the aging Column contains a number between =0 and <=30 I want it to sum
up the counts that correspond in field B2.

I tried the following and keep getting invalid returns.

=SUM(IF(MATCH("<=30",Sheet2!F:F,0),INDEX(Sheet2!B: B,MATCH("<=30",Sheet2!F:F)),0))