Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel date scheduling not msProject | Excel Worksheet Functions | |||
SUMPRODUCT between date range | New Users to Excel | |||
Calc. Avg. Instead of SUMPRODUCT | Excel Worksheet Functions | |||
SUMPRODUCT calc question | Excel Worksheet Functions | |||
if, sumproduct, help by date | Excel Worksheet Functions |