Count if

Z

Zb Kornecki

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
 
B

Bob Phillips

=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)
 
B

Bernard Liengme

Z

Zb Kornecki

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
 
B

Bob Phillips

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 messageI'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>>>>>>
 
Z

Zb Kornecki

Thank's for the help, The info links were excellent, I'd rather learn how to
do then have to keep asking. thanks again Zb
 
Top