View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Wheeler Mike Wheeler is offline
external usenet poster
 
Posts: 1
Default Count a cell in month format

Cell data:
15-Feb REG
22-Feb REG
8-Mar REG
15-Mar REG
15-Mar REG
29-Mar APIN
29-Mar REG
29-Mar REG
29-Mar REG
29-Mar APIN
29-Mar APIN
5-Apr SHOP
12-Apr APIN
12-Apr APIN
26-Apr SHOP
Pulled NSTA
Pulled NSTA
Pulled NSTA
Pulled SHOP
Pulled SHOP
Pulled NSTA


The above columns are C and D, and I am trying to force A1 to give me a
count when column C is in the month of March, and D = "reg". I have a macro
that filters C and D by the selected macro, so the month value will need to
change according to the macro. I tried COUNT, and other versions, but it
doesn't like that.

Help?