View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mike the new guy
 
Posts: n/a
Default Formula to sum data from a data range

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