Hi,

The SUMIF won't work, first because the request is to sum 3 columns which
SUMIF does not support.

Cheers,
Shane Devenshire

"Ashish Mathur" wrote:

Hi,

You can also do the following. In column E, use a SUM() formula

Now in a blank cell, use the formula =sumif(A2:A5,"Scott",E2:E5).

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Craig Deutsch" wrote in message
...
This is probably simple, but I cannot figure it out. Question refers to
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",B2:D5). I know
there's
something wrong with my Sum_range, but I cannot figure it out. Any help
is
appreciated. Thank you.