|
More Count Help Please
How do you get the COUNT function to count a range of ROWS based on 2 conditions? i.e if the row contains A AND B it counts 1 but if the row contains A but NOT B it counts 0 and if the row does NOT contain A but DOES contain B it counts 0 any ideas? many thanks -- SamGB ------------------------------------------------------------------------ SamGB's Profile: http://www.excelforum.com/member.php...o&userid=31263 View this thread: http://www.excelforum.com/showthread...hreadid=510334 |
More Count Help Please
=IF(AND(COUNTIF(1:1,"A"),COUNTIF(1:1,"B"),1,0)
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "SamGB" wrote in message ... How do you get the COUNT function to count a range of ROWS based on 2 conditions? i.e if the row contains A AND B it counts 1 but if the row contains A but NOT B it counts 0 and if the row does NOT contain A but DOES contain B it counts 0 any ideas? many thanks -- SamGB ------------------------------------------------------------------------ SamGB's Profile: http://www.excelforum.com/member.php...o&userid=31263 View this thread: http://www.excelforum.com/showthread...hreadid=510334 |
| All times are GMT +1. The time now is 11:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com