add the Ds

=SUMPRODUCT(--($B$2:$B$2000<""),--(INT((MONTH($B$2:$B$2000)+2)/3)=1),$D$2:$D$2000)--HTHBob(there's no email, no snail mail, but somewhere should be gmail in my addy)"Zb Kornecki" <zDOTkorneckiATcomcastDOTnet wrote in ... I'm sorry I was unclear when I worded the question the dates are in col band the values that are counted in col d "Bob Phillips" wrote: =SUMPRODUCT(--($B$2:$B$2000<""),--(INT((MONTH($B$2:$B$2000)+2)/3)=1)) for quarter 1 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in myaddy) "Zb Kornecki" <zDOTkorneckiATcomcastDOTnet wrote in message ... I have a years worth of dates in Col B and need to do countif and countblank in Col D but I need to seperate by quarters, I was thinking of doingit w/ an if statement but didn't work, I could sort by date and copy to individual worksheets but I have 3 tables w/ 45K+ records each and need to count multiple col. I would prefer to do this a formula, If this can't be done I an do ashort vba script thanks Zb