Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|