Mitchell,
This what you mean ?
=SUMIF(A1:A8,"Pod 1",B1:B8)

NickHK

"Mitchell" ...
I have 2 columns, one contains "Pod 1", Pod 2" with each row having a pod
value. I need to add the numbers in a different column when the value in
the
Pod column matches my designator. I have 3 rows with Pod 1 so I would add
the
3 numbers in a different column.