View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sherobot sherobot is offline
external usenet poster
 
Posts: 26
Default Looking for certain months and summing the totals

Hi
I need a formula to first look for all of january date, febuary dates, etc.
and total them under check amount column. Hope this is clear.thank you

Amount Date Check Amount Month
$320 1/29/2008 $1,886.24 Jan
$40 1/29/2008 Feb
$140 1/29/2008 Mar
$80 1/29/2008 Apr
$80 1/29/2008 May
$1,200 1/29/2008 Jun
$280 2/30/2008 Jul
$1,200 2/31/2008 Aug
$80 3/1/2008 Sep