Calculating specific columns

[datadummy]

I am attempting to calculate if column H has a specific name in it ex. John Smith and then sum column O which has numbers in it. Not sure the best way to accomplish this or what formula to use. Any help would be appreciated!

 

[Panda XXIV]

I am attempting to calculate if column H has a specific name in it ex. John Smith and then sum column O which has numbers in it. Not sure the best way to accomplish this or what formula to use. Any help would be appreciated!

hi you can try this one

=SUMIF(H:H,"John Smith",O:O)

 

[datadummy]

Perfect that did it, I was overcomplicating the sumif function.