SUM PRODUCT FUNCTION

[Sue NY]

I think I need to use the SUMPRODUCT function but need help w/ the formula.

Using the following data:
Investor Name Payment Due Date Payment Amount
Sue 01/01/07 $10
Charlie 09/01/08 $20
Fred 12/08/08 $100
Charlie 01/01/06 $50
Fred 09/16/07 $100
Sue 10/01/08 $75
Sue 12/15/08 $100

I need the formula to find all payments for each investor and total only the
ones that are due later than 08/01/08. So the result should show:

Sue - $175
Charlie - $20
Fred - $100

thanks!

 

[Peo Sjoblom]

=SUMPRODUCT(--(A2:A50="Sue"),--(B2:B50>DATE(2008,8,1)),C2:C50)

replace "Sue" with a cell reference where you would put the name instead

--


Regards,


Peo Sjoblom

 

[Duke Carey]

Assuming you have the payment data in columns A-C, starting in row 2, and
that the unique Investor Names are in column E, also starting in row 2, and
the date you want to compare is in D1:

=SUMPRODUCT(--(A$2:A$1000=E1),--(B$2:B$1000>$D$1),C$2:C$1000)

 

[Reitanos]

Does anyone know of a good reference for SUMPRODUCT?

 

[Peo Sjoblom]

I assume you mean with regards to the unintentional use of SUMPRODUCT as
shown in these examples
and not what it was meant to be.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html



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

--


Regards,


Peo Sjoblom

Does anyone know of a good reference for SUMPRODUCT?

 

[Reitanos]

Yes. Thank you!

I have used it several times to my advantage, but never really
understood how it worked; all the documentation I could find focused
on the "original" intention of the formula and not the expanded use it
now sees.