| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells with particular month and year
Thanks to help previously received, I have been using this formula to count
the number of referrals received in a particular month. Is it possible to include the year as well? =SUMPRODUCT(--(MONTH(A2:A10)=Stats!A1),--(ISNUMBER(B2:B10))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting data for month and year | Excel Discussion (Misc queries) | |||
| Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
| Counting distinct entries based on meeting month & year criteria | Excel Worksheet Functions | |||
| Counting Entries by Month and Year | Excel Worksheet Functions | |||
| counting date entries by month & year | Excel Worksheet Functions | |||
Threaded Mode
