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