Try...

=SUMPRODUCT((SUBTOTAL(3,OFFSET(A1:J10,ROW(A1:J10)-MIN(ROW(A1:J10)),0,1))
0)*(A1:J10="North"))

Hope this helps!

In article ,
"Sam via OfficeKB.com" wrote:

Hi Domenic,

Yes, I have no headers but some data will be filtered.

Thanks
Sam