Help with nesting

[jdonham]

I have three columns:

First; persons name
second; $amount
third; date

I am trying to add the second column only IF first column = correct name AND third column >= 6/30/11

can someone please help me with this function? I am new and not sure what to use hear.

thank you,

[outjet]

what do you mean by "correct name" and what do you want to add the second column to?

[daddylonglegs]

Try SUMPRODUCT, something like this

=SUMPRODUCT((A$2:A$100=E2)*(C$2:C$100>=DATE(2011,6,30)),B$2:B$100)

where E2 contains the correct name

[jdonham]

Try SUMPRODUCT, something like this

=SUMPRODUCT((A$2:A$100=E2)*(C$2:C$100>=DATE(2011,6,30)),B$2:B$100)

where E2 contains the correct name

This worked perfectly! thanks for the help!