=SUMPRODUCT((LEFT(A5:A8,3)="009")*B5:B8)


"Thyag" wrote:

Hi All,

Could somebody can provide with a formula to sum Column B data for all
the data that start with "009" in column A

Ex - The formula should give me 100 as answer.

Column A Column B
00911 60
00111 30
00112 20
00922 40

Thanks in Advance.
Thyag