| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count month when date is in day/month/year format | Excel Worksheet Functions | |||
| Count numbers of Month in a cell | Excel Worksheet Functions | |||
| count the occurrences of a month in a date&time cell | Excel Worksheet Functions | |||
| Count duplicate cell values per month | Excel Worksheet Functions | |||
| How can I format a cell so date field only displays the Month? | Excel Discussion (Misc queries) | |||
Threaded Mode
