Try this approach:

=SUMPRODUCT((LEFT(A1:A1000,3)="000")*(P1:P1000))

I've assumed 1000 rows, so adjust to suit, but you can't use full
column references prior to XL 2007.

Hope this helps.

Pete


On Mar 31, 8:04*pm, "Gaurav" wrote:
I need to sum column P if values in column A begin with 000.

any ideas?