I have a spreadsheet with a list of names spread throughout a column (Column A) and some numbers in the next few column (Column B, C, D, E) I'm trying to set up in Column F the ability to use the IF function to pick out certain names (Mike F for example) then add up the corresponding numbers found in the columns next to that name. Now Mike may be listed several times in Col A the way I've set up the statement it's adding up all the numbers in my given range no matter what name is in Col A. Here is the way I've got the function set up:

=if(A4:A200="Mike F", Sum(B4:B200)+sum(C4:C200)+sum(D4:D200)+sum(E4:E200),0)

Is there another way to accomplish what I'm trying to do or can it not be done because it doesn't seem to be looking for Mike in Col A, if I put a number next to Andrew it returns that number instead of 0.
Any help with this is greatly appreciated.
Thanks
Bob