I'm sorry I was unclear when I worded the question the dates are in col b and
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 my addy)

"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 doing it
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 a short
vba script thanks Zb