countifs

Gregw

I have a sheet A with Client name and status, I have a sheet B with the data, I want to search every row of sheet B for the client and status of completed live or completed live missing docs.

=countif({Sheet B Range 1}, [client name]1, (Sheet B Range 2), OR(@cell = "Completed - Live", @cell = "Completed - Live - Missing Documentation"))

individually these work together it returns 0

any help would be great

Victoria_Indimar

Hello @Gregw . The formula looks good but it should be COUNTIFS since you have two criteria you're matching on. I've bolded the changes below.

=COUNTIFS({Sheet B Range 1}, [client name]@row, {Sheet B Range 2}, OR(@cell = "Completed - Live", @cell = "Completed - Live - Missing Documentation"))

Hope this helps!

Paul Newcome

The parenthesis around the second range need to be swapped out with curly brackets to indicate a cross sheet reference.

Victoria_Indimar

Hello @Gregw . The formula looks good but it should be COUNTIFS since you have two criteria you're matching on. I've bolded the changes below.

=COUNTIFS({Sheet B Range 1}, [client name]@row, {Sheet B Range 2}, OR(@cell = "Completed - Live", @cell = "Completed - Live - Missing Documentation"))

Hope this helps!

Paul Newcome

The parenthesis around the second range need to be swapped out with curly brackets to indicate a cross sheet reference.

Gregw

Thank you so much to both of you!