Bob you RULE!!!!
Thank you SO MUCH for the help!!!!
(My boss is gonna think I'm a genious when she sees this.) Don't worry,
I'll give you credit... : )

"Bob Phillips" wrote:

=SUMPRODUCT(--(B2:B200=--"1998-11-25"),--(B2:B200<=--"1999-11-28"),C2:C200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mike the new guy" wrote in
message ...
Ok here's what I need to do.
My sheet contains list of transactions by date and tx number spread over
several years. I am trying to automatically pull subtotals for each
fiscal
year out of this LONG list of data.

Example:
ID Date IssueAmt Sold Date
1380 12/1/1998 $66.00 12/1/1998
1381 12/1/1998 $66.00 12/1/1998

I need a formula that will sum the "Issue Amounts" if the "Date" falls
within a particular range, ie. 11/25/1998-11/28/1999.

Any help you all can give me I am extremely greatful for. I've been
pulling
my hair out all day today with IF, AND, and OR statements that keep
returning
garbage.

Thanks,
Mike