SUMPRODUCT Not Working

[dj479794]

Excel 2003

Trying to sum all deals for a specific rep in a specific month.

Column A = Months (Entered as JAN, FEB, MAR, APR...)
Column B = Rep (Entered as Last Name)
Column C = Value of deal (Entered in as the monetary amount.

Sample Data: (Columns Seperated by commas)

JAN, Johnson, $50,000
JAN, Smith, $20,000
JAN, Roberts, $15,000
JAN, Johnson, $10,000
FEB, Brown, $5,000
FEB, Roberts $10,000
FEB, Johnson $5,000
......

Wat did Johnson sell in January? Output = $60,000

 

[Bernard Liengme]

=SUMPRODUCT(--(A1:A100="JAN"),--(B1:B100="Johnson"),C1:C100)

do not use full columns as in A:A
How to use Sumproduct:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

http://mcgimpsey.com/excel/formulae/doubleneg.html

It this fails: tell us your formula and the result
best wishes

 

[Dave F]

You don't post your formula so it's impossible to tell you what you're doing
wrong.

In any event, =SUMPRODUCT(--(A1:A10="JAN"),--(B1:B10="Johnson"),--(C1:C10))
would return all sales by Johnson in Jan, assuming the month is in column A,
the sales person's name is in B, and the $ value is in C.

Alternatively, use a pivot table. Much simpler and quicker.

Dave