sheet summary with a count which needs to meet 2 criteria

Sven Krohn

Hi,

I want to display the total number of "types" in a specific "market" through the sheet summery.

If I enter the formulas individually, it works. As soon as I try to combine them with ", and" I´m getting an error message.

Individual formulars:

=(COUNTIF(Type:Type, "blue"))

=(COUNTIF([Market]:[Market], "AT")

combined:

COUNTIF([Market]:[Market], "AT"), AND(COUNTIF([Type]:[Type], "blue"))

I guess I can´t really use COUNTIF twice because it will generate 2 values, but just "IF" is also not working.

Any idea?

Thanks!

Andrée Starå

Hi @Sven Krohn

I hope you're well and safe!

Try using a COUNTIFS instead. It's like a COUNTIF AND.

https://help.smartsheet.com/function/countifs

Did that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Sven Krohn

I hope you're well and safe!

Try using a COUNTIFS instead. It's like a COUNTIF AND.

https://help.smartsheet.com/function/countifs

Did that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sven Krohn

Yes! That did the trick!

Thank you so much!!

Sven

Andrée Starå

@Sven Krohn

Excellent!

You're more than welcome!