=Sumif Query

[Orthodoxyn]

Hi,
I hope someone can help

Im trying to take the first alpha letter of the cell in column B and then total up whats in column C
i.e. the total for Any Cell that contains A would be 1035.

Example attached of what i need to total up.

I am really struggling with this. Is anyone able to help?

Thanks

[Pepe Le Mokko]

Hi
please adapt title per forum rules
also post a sheet instead of a picture - Thx

[Orthodoxyn]

I don't appear to be able to edit the post

[rajeshturaha]

Put all the alpha letters in col a. In col b put formula

Please Login or Register  to view this content.

in col f & g put the total value that u want to summarize, say "a"=1035
in Col "c" put the formula

Please Login or Register  to view this content.

see the attachment