View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Todd Todd is offline
external usenet poster
 
Posts: 177
Default sumproduct date calc.

Hi I am trying to sum a column of numbers by month and am having trouble with
the formula (see below). I am getting a return of VALUE. Any ideas where I
am going wrong?

Thanks


Todd

=SUMPRODUCT((MONTH(J2)=MONTH($H2:$H$300)),F$2:F$30 0)

F H j2
cost date requested Month
$12.46 1/6/2006 1/00/2006
$200.70 1/19/2006
$53.22 1/6/2006
$471.84 1/7/2006
$25.35 2/9/2006
$33.00 2/11/2006
$346.98 2/14/2006
$3.82 2/15/2006
$99.42 2/8/2006