|
|
#1
04-30-2014, 03:36 PM
|
|||
|
|||
CountiF or CountiFs two columns conditions
Have Column B which has those numbers that are repeated
B7 993925968 B8 993925968 B9 993925968 B10 993925968 B11 992308642 I have column C which has a specific text message = Blast Email Now i need to get the Distinct Count of Column C Since the numbers are repeated in column B, then the count for column C message should be 2. But my formula =COUNTIF($C$9:$C$90,"Blast Email") does not work for me. Attached an excel sheet with the example 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| COUNTIFS Help Needed | OTPM | Excel | 2 | 04-09-2014 08:32 AM |
 multiple conditions, and blank cells with the countifs function
|
jaden0605 | Excel | 1 | 03-30-2014 01:50 AM |
| Compound Countifs Query not working | Lonercom | Excel | 5 | 06-28-2013 10:27 AM |
|
Countifs and Sumproduct
|
Algo | Excel | 6 | 11-13-2012 07:44 AM |
| countifs? | sonyaturpin | Excel | 1 | 05-23-2012 08:29 AM |
Windows XP 
Office 2003
Threaded Mode