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.