sum if
 

The values in [Data.xls]Register!$B$2:$B$10000 are dates like 03/22/05

=SUMIF([Data.xls]Register!$B$2:$B$10000,MONTH(TODAY()-15),[Data.xls]Register!$AI$2:$AI$10000)
it just returns zero
im sure its the MONTH part thats messing it up, but i cant figure out a
solution

thanks in advance

Try

=SUMPRODUCT(--(MONTH([Data.xls]Register!$B$2:$B$10000)=MONTH(TODAY()-15),[Da
ta.xls]Register!$AI$2:$AI$10000)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"choice" wrote in message
...
The values in [Data.xls]Register!$B$2:$B$10000 are dates like 03/22/05


=SUMIF([Data.xls]Register!$B$2:$B$10000,MONTH(TODAY()-15),[Data.xls]Register
!$AI$2:$AI$10000)
it just returns zero
im sure its the MONTH part thats messing it up, but i cant figure out a
solution

thanks in advance