Hi all,

I would like to sum more than one column on a given row that matches my
critera.

My data is set up with sales information by style/store like this:
A B C D
1 STYLE# STORE 1 STORE 2 STORE 3
2 0001 13 11 8
3 0002 5 7 4

I'd like to find the Total Sales (Store 1 + Store 2 + Store 3) for a given
Style #

I've tried entering indicating more than one column in the sum range:

SUMIF(A2:A3,"0001",B2:C3)

From my reading of Excel help it seems like this should work but it is only
adding numbers in the first column of my range; am I doing something wrong?

I can't change the file that I'm pulling the data from, so adding a total
column and then pointing to that wouldn't work.

I could add an intermediate file with the totals for each style and point to
that but I feel like there has to be a better way...

Any ideas would be appreciated.

Thanks!!!