One way...(I think)...

=sumif(a:a,"="&0,b:b) - sumif(a:a,""&30,b:b)



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))

--

Dave Peterson