return the value if the criteria meet 45 days and the name of the client is not empty.

System

This discussion was created from comments split from: Count If and Not blank.

Pamella Souza

Hi All,

Can someone help me with the following?

I am trying to use the same formula but referencing a different sheet, I tried several variations, but nothing works.

(#INCORRECT ARGUMENT)

=IFERROR(COUNTIFS({TEST - Implementation 2024 (Range 45)}, "YES", {TEST - Implementation 2024 (Range Customer)}, <>""))

I need to return the value if the criteria meet 45 days and the name of the client is not empty.

Thanks in advance.

Paul Newcome

@Pamella Souza You are forgetting to include the second portion of the IFERROR statement that tells it what to output if the COUTNIFS throws an error.

=IFERROR(COUNTIFS({TEST - Implementation 2024 (Range 45)}, "YES", {TEST - Implementation 2024 (Range Customer)}, <>""), "value if error")

Pamella Souza

@Paul Newcome Thank you for your prompt response.

The IFERROR was my last attempt. What I really want to accomplish here is to count the lines that meet the following criteria (meeting 45 days and a customer name in the customer column).

My original formula is the following:

=SUM(COUNTIF({TEST - Implementation 2024 (Range 45)}, "YES") + COUNTIF({TEST - Implementation 2024 (Range Customer)}, <>" "))

But it is not returning the right value, and I have no idea why.

Thank you!

Paul Newcome

Try it with just the COUNTIFS.

Pamella Souza

@Paul Newcome Thank you!

It's working now.

I found the error. Because I had changed it way too many times, the reference range was wrong, and I was missing quotes on one side. Thanks again for the assistance!