sheet summary with a count which needs to meet 2 criteria


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")


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?


Best Answer