SUM with Multiple Criteria

[NS]

Hi!

I am stumped on how to write an EXCEL formula that will sum the values
in one column based on multiple criteria from other columns. Here is
the example.

I have these three colummn.

PLAN DATE PAYMENT
WG 2005/4/12 $ 100.00
WG 2005/1/21 $ 150.00
WG 2005/3/21 $ 50.00
TF 2005/5/12 $ 500.00
TF 2005/4/24 $ 250.00
TF 2005/4/4 $ 250.00
TF 2005/6/21 $ 125.00
VG 2005/4/16 $ 100.00
VG 2005/3/23 $ 100.00
VG 2005/3/14 $ 100.00

I want to sum the Payments where PLAN = TF and where the DATE is
between 2005/4/1 and 2005/4/30.

Any ideas? Thanking anyone in advance for their help! Greatly
appreciated!

Nadine

 

[Earl Kiosterud]

Nadine,

Did you respond to your own post?

Try this array formula (use Ctrl-Shift-Enter instead of Enter):

=SUMPRODUCT((A2:A11="TF")*(B2:B11>=DATEVALUE("4/1/2005"))*(B2:B11<=DATEVALUE("4/30/2005"))*C2:C11)

 

[Earl Kiosterud]

Nadine,

Oops. You don't have to enter that as an arry formula after all. Just use
Enter.