Try this...

=SUMPRODUCT(SUBTOTAL(2,OFFSET(G3:G33,ROW(G3:G33)-ROW(G3),0,1)),--(G3:G330),G3:G33)

--
Biff
Microsoft Excel MVP


"Sarah H." wrote in message
...
Hi, guys,

I searched around on the web but I can't find how to do a conditional
subtotal in Excel 2007.

E.g., =subtotal(9,g3:g330) (if that would only work). It seems
impossible.

Thanks for any insight,
Sarah