IF one column is a specific value then add the cell in another column

[AnnaV]

I have names in column E and I have values in column S. I want the formula to add the numbers in column S if a certain name is in column E.

Example: If Bob is in column E add the corresponding values from column S.

[Domenic]

Try the following...

=SUMPRODUCT(--(E1:E100="Bob"),S1:S100)

OR

=SUMPRODUCT(--(E1:E100=A1),S1:S100)

...where A1 contains the name of interest.

Hope this helps!

I have names in column E and I have values in column S. I want the formula to add the numbers in column S if a certain name is in column E.

Example: If Bob is in column E add the corresponding values from column S.

[AnnaV]

That worked great. Thanks!

What does '---' mean?

[Domenic]

That worked great. Thanks!

What does '---' mean?

Have a look at Aladin's explanation here...

http://www.mrexcel.com/board2/viewtopic.php?t=103530

Hope this helps!