( by Absolute Zero )
Google Chrome / Windows 7
Have a look at the following screenshot of my Spreadsheet:
I have the data in Column A and B.
I have the value "ML" in Cell D1 and I have the following formula in Cell E1:=sumif(A:A;D1;B:B)
I have the value "AVAT" in Cell D2 and I have the following formula in Cell E2:
And if you want to total for all the values in Column A, then you can also get the summing of Column B using group by query. I have the following formula in Cell H1:
=query(A:B;"select A,sum(B) where A<>'' group by A label sum(B) '' ")
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.