B
Ben Johnson
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!!!
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!!!