=COUNTIF() - "Yes", "No" and "" (blank)?

[domgilberto]

Hey all!

To start off with:

Please Login or Register  to view this content.

That doesn't seem to work?

I also want the same for "No" too?

Likewise, how can I count a blank box in column J ONLY IF there is a date in C15:C10000?

-------------------------------------------------------------------------------------------------

On top of that, can I find out how many "Yes", "No" and "" (blank) there was in the specific month?

It will need to look at J15:J10000 for Yes, No and blank box, then look at C15:C10000 for "Site Attended" (DD/MM/YY) - then D15:D10000 "Report Received" (DD/MM/YY)

Rules are: Column J will be blank if NOTHING is in D column. Column J will have Yes or No in it IF column C has a date in it...


Thanks

[dourpil]

Hi!

1: Try =countif(J15:J10000,"Yes")
2: Same for No


Excel sees dates as numbers (formatted as a date). So according to what could be in J5:J10000 you could try
=countifs(J15:J10000,"",C15:C10000,">10000")

As you can see the condition on C column is ">10000" which translates to a date > 18/05/1927.

------------------------------------------------------------------------------------------------------
=countifs(J15:J10000,"Yes",C15:C10000,">=1/1/14",C15:C10000,"<2/1/14") could work although it probably could be done more effectively

[icestationzbra]

please share a sample workbook with desired results indicated.

UPDATED

[domgilberto]

please share a sample workbook with desired results indicated.

If I wanted to include names in column "B" and find out how many "Yes" and "No" they had against there names, how can I figure that out?

I.e. - Reports received = (Yes + No's total)
- Reliability (%) = (Percentage of Yes over No's)
- Outstanding = (Number of blank boxes BUT have a name in B and a date in C)...

[dourpil]

Could you react to what has been proposed to you and tell us if that meets any of your requirements? You should have stuff to work with atm.

[domgilberto]

Hey guys - sorry about the delay, I am flat out at the moment, I will however come back once I have had a chance to look over what's been done

Thank you so much for your input!!