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 |
All times are GMT +1. The time now is 02:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com