| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Try this, with the date in Column N:
=SUMPRODUCT((M8:M78="Metro")*(MONTH(N8:N78)=10)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "zbert" wrote in message ... The following countif function works well for me but I was wondering how I could use a date range criteria from a different column. I want to count all ocurrences of "Metro" in the month of Otcober. =COUNTIF('PRT Metrics'!M8:M78,"Metro") This formula counts all occurences of the word "Metro" in the range M8:M78. I'd like to count all occurence within a given month. -- zbert ------------------------------------------------------------------------ zbert's Profile: http://www.excelforum.com/member.php...o&userid=15920 View this thread: http://www.excelforum.com/showthread...hreadid=274000 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating an EXCEL COUNTIF formula for a range of values | Excel Discussion (Misc queries) | |||
| COUNTIF using formatting? | Excel Discussion (Misc queries) | |||
| Pivot Table - using Countif in place of Count,Sum, etc. | Excel Discussion (Misc queries) | |||
| CountIF cells are not empty | Excel Discussion (Misc queries) | |||
| Subtotal And Countif | Excel Discussion (Misc queries) | |||
Threaded Mode
