Simple If statements

[ranger35603]

I'm trying to make spreadsheet to log my wife and mine medical bills. In column H we list our name. In column G we list the amount of the bill. How do I write a formula to first reference the name in column H and sum the bills? Example if column H says Mary...then add the bill shown in column G. I want to create a sum total for Mary and a separate cell reference total for myself. Pretty simple > I can't figure it out.

 

[Brian from Maui]

Try,

=SUMIF(NameRange,"Mary",RangeToSum)

 

[ranger35603]

It worked! Thank you! I tried for almost 1.5 hours on my own and now got this "fixed" in minutes!