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