=SUMPRODUCT(--(Sheet2!F1:F1000=0),(--(Sheet2!F1:F1000<=30),
Sheet2!B1:B1000)
You cannot use full column references with SUMPRODUCT except in Excel 2007+
And if you have Exel2007 then you could use
=SUMIFS(Sheet2!B:B,Sheet2!F:F,"=0",Sheet2!F:F,"<= 30")
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Heather" wrote in message
...
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))