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!

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

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

--


Regards,


Peo Sjoblom

"Sue NY" <Sue wrote in message
...
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!

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)


"Sue NY" wrote:

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!

Does anyone know of a good reference for SUMPRODUCT?

On Aug 7, 2:42*pm, Duke Carey
wrote:
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)

"Sue NY" wrote:
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!

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

"Reitanos" wrote in message
...
Does anyone know of a good reference for SUMPRODUCT?

On Aug 7, 2:42 pm, Duke Carey
wrote:
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)

"Sue NY" wrote:
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!

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.

On Aug 7, 3:02*pm, "Peo Sjoblom" wrote:
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

"Reitanos" wrote in message

...
Does anyone know of a good reference for SUMPRODUCT?

On Aug 7, 2:42 pm, Duke Carey
wrote:

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)

"Sue NY" wrote:
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!