Using COUNTIFS with multiple conditions

Andrée Starå

Would it work with a report instead?

If it wouldn't.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

P.Bushong

Thanks for your feedback.  As it turns out I had the wrong syntax.

From the beginning of this post the solution was this formula:

=INDEX({Sheet 2 Active Column}, MATCH([Site Name]@row, {Sheet 2 Site Column}, 0))

 

After going back to look I have found the issue, as I had a 1 instead of a 0.  

=INDEX({Sheet 2 Active Column}, MATCH([Site Name]@row, {Sheet 2 Site Column}, 1))

 

I changed it to 0 and now it is working properly

Paul Newcome

That'll do it. I have found that I get the most accurate and consistent results using the 0 within the MATCH instead of the 1.

 

Glad you got it working.

Andrée Starå

Excellent!

Happy to help!