CountIF

PDunn

I want to count the number of CatSeries that match and have transitioned in the Priority/Status column.

=COUNTIFS([CatSeries Concat]:[CatSeries Concat], @cell, [Priority/Status]:[Priority/Status], "transitioned")

Kelly Moore

Hey @PDunn

Try this

=COUNTIFS([CatSeries Concat]:[CatSeries Concat],CatSeries Concat]@row, [Priority/Status]:[Priority/Status],"Transitioned")

Will this work?

Kelly

Kelly Moore

Hey @PDunn

Try this

=COUNTIFS([CatSeries Concat]:[CatSeries Concat],CatSeries Concat]@row, [Priority/Status]:[Priority/Status],"Transitioned")

Will this work?

Kelly

PDunn

Hi @Kelly Moore Yes it worked I just couldn't get the order of operation correct thank You :)