If Range has certain value, add corresponding value from other col

[Katie]

I have found numerous questions around this subject using dates, but none
that match perfectly so I figured I'd ask the experts.

I have a column of names repeating each day (Column B) and a column of how
many samples were taken from that person on that day. (Column D) What I'm
trying to do is say, "Every row that column b equals, "John Smith", sum the
corresponding column d"

I can't figure out a way to do this using the IF or SUM statements. Any help
would be appreciated. Thank you.

 

[Ardus Petus]

=SUMIF(B:B,"John Smith",D)

HTH

 

[Katie]

Thank you so much. I feel stupid, I kept trying to use arrays and it wasn't
working. Thank you.