Combining IF and COUNTIF statements

[Silha]

Hello there,

I'm not sure if the subject of this thread accurately reflects what I want to be able to do, but it's the closest description I could think of!

I need a formula that gives me the answer to this formula
=COUNTIFS(AD3:AD1383,"yes")

The above formula is based on the answers in each cell of the column that runs this formula
=IF(AND((NETWORKDAYS($AF$11,C3))>0,LEN(F3)>0),"yes","no")

Basically, I want to find out how many projects in my report were delivered late. I just need that one number and I don’t want to add the extra column to my report which says whether a project was late or not and then count up the results of that.

I know I can continue to use the above two formulas, cut and paste values and then delete the column before sending out the report, but I want to cut out that step and just end up with the figure I need. I'm sure this can be done but I don't know enough about Excel to know how I would do it.

Hope this makes sense and thank you in advance for your help!

 

[njimack]

Can't test the below as you haven't supplied a sample of data, but this should be what you're after:
=SUMPRODUCT(--(NETWORKDAYS($AF$11,C3:C1383)>0),--(LEN(F3:F1383)>0))

 

[bruderbell]

With many functions, you could do what you're seeking in an array formula. However, NETWORKDAYS doesn't play nice...
http://www.mrexcel.com/forum/excel-questions/60277-array-formula-using-networkdays.html

 

[Gavin T]

You can hide the columns you don't want to be visible in your report.

 

[Silha]

Thank you, all.

In the end, I ended up using Gavin's suggestion and just hiding the column.

Njimack, thank you for the formula but unfortunately, it did not work!