Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |