Hi,
Quote:
|
Next I want to count the number of "x"s per column that also have a name in column C but I cant get it to work quite right,
|
So here you have 2 conditions per row
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")