C

#### Craig Deutsch

table below:

Column A Column B Column C Column D

=============================

Julie 600 200 300

Scott 100 200 400

Tom 132132 111 4000

Craig 100 1000 100

Question: I'm trying to help a colleague calculate the value across a row

for Columns B-D when a value in Column A matches the criteria. For example,

I want Excel to calculate the totals for Scott. The result should be 700.

The formula I'm using is this: =SUMIF(A2:A5,"Scott",B25). I know there's

something wrong with my Sum_range, but I cannot figure it out. Any help is

appreciated. Thank you.