• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Assistance with a COUNTIFS formula please

R

Razorbec

New Member
I have written the formula:

=COUNTIFS(Export!C:C,"PV Order",Export!E:E,"ACT",Export!J:J,"")

The "" does not seem to be working to count blank fields. Does anyone know how I could fix it?

The first 2 conditions work, but once I add the third in, I just get a result of zero.

Thank you.
 
@Razorbec Welcome to Chandoo.org and thanks for posting your question.

May be your column J is not truly blank. May be the values are 0 (often shown as blank) or empty spaces. I suggest posting sample data so that we can examine what is going on with your data.
 
Hi ,

Your formula works correctly when I try it out , irrespective of whether cells in column J are truly blank or having nulls through formulae such as :

=IF(condition to be checked , "" , value if false)

As Chandoo has already posted , the problem might be with the data itself in column J.

Narayan
 
In addition to what you have already asked.

If you make change in criteria range the something like below will also helpful.

=SUMPRODUCT(--((Export!C1:C1000="PV Order")*(Export!E1:E1000="ACT")*(LEN(Export!J1:J1000)=0)))
 
You must log in or register to reply here.
Back
Top