Multiple Count Criteria
Which function do I use to count all of the rows that have both the
numberical value 0 in column C AND the words "Star quality" in Column L? |
Multiple Count Criteria
=SUMPRODUCT(--(C1:C1000),--(L1:L100="Star quality")) Adjusting ranges to suit -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=493597 |
All times are GMT +1. The time now is 01:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com