Sumif function problem

[Thyag]

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

 

[Joel]

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

 

[Bob Phillips]

=SUMIF(A:A,"009*",B:B)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Thyag]

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

Thanks Joel and Bob.