Thread: Count if
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zb Kornecki Zb Kornecki is offline
external usenet poster
 
Posts: 23
Default Count if

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