sumif function not giving the correct total

A

ashmad73

New Member
Joined
May 24, 2012
Messages
1
Hi,

I'm trying to add the total product sold by a group of sales person for example : Chad + Javier. My actual worksheet includes 600 rows of salespeople and 20 rows of product, i'm using this simple example to get the message across.

I was using =sum(sumif(A1:A9,"Chad',D1:D9),sumif(A1:A9,"Javier",D1:D9)), the formula should have given 91, but instead is calculating 113...

what am i doing wrong?


Salers Person Product A Product B Product C
Chad 5 6 7
Chad 5 6 7
Chad 5 6 7
Chad 5 6 7
Chad 5 6 7
Chad 5 6 7
Ross 5 6 7
Ross 5 6 7
Ross 5 6 7
Ross 5 6 7
Ross 5 6 7
Ross 5 6 7
Javier 5 6 7
Javier 5 6 7
Javier 5 6 7
Javier 5 6 7
Javier 5 6 7
Javier 5 6 7
Javier 5 6 7
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
Hi Ashmad and welcome to the Board
You may have to chack your data, I get 91 from the sample provided.
I also note that the formula you used only goes down to row 9


Excel 2003
ABCD
1Chad567
2Chad567
3Chad567
4Chad567
5Chad567
6Chad567
7Ross567
8Ross567
9Ross567
10Ross567
11Ross567
12Ross567
13Javier567
14Javier567
15Javier567
16Javier567
17Javier567
18Javier567
19Javier567
20
2191
Sheet1
Cell Formulas
RangeFormula
D21=SUM(SUMIF(A1:A19,"Chad",D1:D19),SUMIF(A1:A19,"Javier",D1:D19))
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Calculate last 5 soccer team goals using data from another sheet on same workbook.
2
Replies
19
Views
951
felixstraube
F
B
  • Solved
Extracting last name from full name
2
Replies
16
Views
834
bearcub
B
K
  • Question
AVERAGEIFS / SUMIF with multiple criteria
Replies
3
Views
845
arthurbr
arthurbr
L
  • Question
Index match working but not all information being brought in
Replies
3
Views
355
Peter_SSs
Peter_SSs
Y
  • Question
sum total in specific column when it complete 1 quantity in column H
Replies
0
Views
286
yoon
Y

Forum statistics

Threads
1,215,446
Messages
6,124,896
Members
449,194
Latest member
JayEggleton

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top