![]() |
|
#1
|
||||
|
||||
![]()
Hi,
Quote:
Condition 1: Column C is not blank AND Condition 2: Column F is equal to "X" COUNTIF() can't do that, but a new function in Excel 2007 called COUNTIFS() can. =COUNTIFS(Input!C:C,"<>",Input!F:F,"X") |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
CountIF in R1C1 With Ampersand and Address Reference | MicronExcel | Excel | 3 | 02-12-2012 06:49 PM |
COUNTIF and Cell address problem | ColinC | Excel | 3 | 12-24-2011 04:08 AM |
![]() |
jujuwillis | Excel | 2 | 10-15-2011 11:06 AM |
![]() |
geoffm | Excel | 1 | 08-16-2011 11:31 AM |
![]() |
ibrahimaa | Excel | 3 | 05-23-2011 11:23 AM |