I have a workbook with just 2 sheets, the first sheet is where data is input. Basically what you need to know is:
1st sheet
Column C: Estimators Name


E: Contract Amount
F-U: how the company heard about us (each column has a header with a different source and an "x" is placed in the proper column)

on the 2nd sheet I want to count the total number of "x"s in each column, which I was able to do
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, I've tried vlookups combined with countif(and but the closest ive gotten is using:

=IF(Input!C:C="","",COUNT(Input!F:F,"x"))

but it doesn't output the correct number.

Please Help!

Katy

Hi,

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")

__________________
Colin

RAD Excel Blog

wow thank you so much!