Sumif with multiple columns in sum_range
On Mar 14, 11:10*am, dza7 wrote:
Hello,
I have a set of data that has a label in column A the sales in column
B, C & D:
Column A * * * *Column B * * * *Column C
Joel * * * * * * * *500 * * * * * * * * *677
Joel * * * * * * * *575 * * * * * * * * *752
Joel * * * * * * * *650 * * * * * * * * *827
Claudia * * * * * 725 * * * * * * * * *902
Tarzan * * * * * *800 * * * * * * * * *968
I'd like to run SUMIF where the "Range" is column A, the "Criteria" is
Joel, and the "Sum_Range" is B:C but when I use SUMIF(A:A,"Joel",B:C)
I only get the sum of column B which is 1,725.
Can someone hook me up with a formula that can sum both column B & C
in this situation.
Thanks, in advance
Daniel
something something
|