Home |
Search |
Today's Posts |
#1
|
|||
|
|||
COUNTIF Question
Ragdyer Wrote: =SUMPRODUCT((M8:M78="Metro")*(MONTH(N8:N78)=10)) Thanks so much for the quick reply. Your formula worked perfectly. I modified it slightly to reference another worksheet but it still worked well. Here's what I ended up with. =SUMPRODUCT(('PRT Metrics'!M8:M78="Metro")*(MONTH('PRT Metrics'!G8:G78)=10)) Also, thanks to Aladin Akyurek for his suggestion. I just tried your's because it looked like a more concise solution to my problem. --zbert -- zbert ------------------------------------------------------------------------ zbert's Profile: http://www.excelforum.com/member.php...o&userid=15920 View this thread: http://www.excelforum.com/showthread...hreadid=274000 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list question | Excel Discussion (Misc queries) | |||
Pivot Table - using Countif in place of Count,Sum, etc. | Excel Discussion (Misc queries) | |||
Subtotal And Countif | Excel Discussion (Misc queries) | |||
Have a question on scrolling sum with Excel. | Excel Worksheet Functions | |||
COUNTIF Question | Excel Worksheet Functions |