Count Rows with Multiple Criteria

Steglio

Hi all,

I am trying to count the Row withe multiple criteria

In this case, I want to count the rows where I have "Rib Drg" & "-A-"

I have tried with Countif and Countifs with the OR & AND but could not work it out

Thanks!

Steglio

Pressend post comment too soon. Please see screenshot

Matt Johnson

Hi @Steglio

Maybe give this formula a try.

=COUNTIFS(Provider:Provider, "Rib Drg", [Status Received]:[Status Received], "-A-")

I hope that helps.

Matt

Steglio

Hi Matt, thank you very much, that worked!

What if I want to add another criteria in the provider column like

Rib Drg & Mark Drg?

thank you