Sumif function problem
 

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

Sumif function problem
 

=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

Sumif function problem
 

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

--

HTH

Bob Phillips

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

"Thyag" wrote in message
...
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

Sumif function problem
 

On Dec 21, 9:40*am, 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

Thanks Joel and Bob.