I see you have an answer from Bob that works for you, but you might
like to try this amendment:

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

Hope this helps.

Pete

On Mar 31, 8:54*pm, "Gaurav" wrote:
Thanks Pete...but i am getting the VALUE errror as result.

"Pete_UK" wrote in message

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