Sum salaries of people whose name starts with "A"

Screen Shot 2014-04-03 at 7.41.35 PM.jpg

I have a list of names and each person's salary here. I want to add the salary of the people whose name starts with "A" (Alex and Andrew in this case). How do I do that?

I thought about LEFT(cell), which returns the first letter, but this applies to one cell only. How do I do this for multiple cells?

Thanks!

Here it is

=SUMIF($A$1:$A$5,"A*",$B$1:$B$5)

	A	B	C
1	Alex	3200	6969
2	John	2500
3	Andrew	1257
4	Aaron	2512
5	Fred	1254

Hi and welcome to the forum

1st...please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

2nd try this...
=SUMIF(A1:A8,"a*",B1:B8)

Like this...

=SUMIF(A1:A8,"A*",B1:B8)

Or, if you want to use a cell to hold the criteria...

D1 = A

=SUMIF(A1:A8,D1&"*",B1:B8)

Try this........

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

Hope that helps.

You're welcome. We appreciate the feedback!