Count number of projects by Manager that is NOT funded

[Eagleblue]

I have an excel sheet that has multiple columns in it, but I am trying to get QLIK to count the number of projects that manager has that is NOT funded.  They usually show up on the excel sheet as a blank cell.  The only time the cell is filled out is if the project is funded.   I can easily count the funded ones, I just can't figure out how to count the projects without a value in the cell.  I can't add to the excel file.  It is automatically generated by a system that only has those values.

[Eagleblue]

Here's an example of what I would be looking at.  Counting how many projects that each Project Manager has that is NOT funded.

[MK_QSL]

Try this

COUNT(DISTINCT {<[Project Name] = {"=Len(Funded)=0"}>}[Project Name])