| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Linear Mode
