if formula .

Tadiwa

I have three columns, I want to get the count if the week is 8, the year is 2023 and the country is US. if that condition is not met I want it to return nothing and have the cell empty.

Can anyone help

=COUNTIFS({Submit FY}, "2023", {week}, [Primary Column]@row, {Country}, "US"))

The formula initially looked like that but it returned zero when condition wasnt met. Now I want it to return nothing

@Paul Newcome

Paul Newcome

There are a number of posts already detailing how to do this, but the basic idea is that you use an IF statement to say that IF the COUNTIFS is greater than zero, output the COUNTIFS.

Paul Newcome

There are a number of posts already detailing how to do this, but the basic idea is that you use an IF statement to say that IF the COUNTIFS is greater than zero, output the COUNTIFS.

Tadiwa

Thank you! That helped

Paul Newcome

Happy to help. 👍️