CountIfs Invalid Ref

Casey A

I cannot for the life of me get this CountIfs function to work. Referencing another sheet. Plz help!

=COUNTIFS({FY23 PWP Meets Objective:Meets Objective}, "No", {FY23 PWP PHC:PHC}, "FFH")

Screenshot of my reference sheet columns and values.

Dale Murphy

@Casey A I have never seen crosslink references that look like that. I don't think you have the info in the swirly brackets right - usually it would just be {sheetname rangenumber} It looks like you are using syntax similar to what you would use if you were referencing a range in the same sheet.

I recommend rebuilding those sheet range references. Start from scratch and let the tool create the syntax for you.

dm

Casey A

Thanks @Dale Murphy, the reference select tool worked this time (was an issue with my view) and this worked: =COUNTIFS({FY23 HCCN Master Work Plan Range 1}, "No", {FY23 HCCN Master Work Plan Range 2}, "FFH"). Appreciated.

Dale Murphy

@Casey A I have never seen crosslink references that look like that. I don't think you have the info in the swirly brackets right - usually it would just be {sheetname rangenumber} It looks like you are using syntax similar to what you would use if you were referencing a range in the same sheet.

I recommend rebuilding those sheet range references. Start from scratch and let the tool create the syntax for you.

dm

Casey A

Thanks @Dale Murphy, the reference select tool worked this time (was an issue with my view) and this worked: =COUNTIFS({FY23 HCCN Master Work Plan Range 1}, "No", {FY23 HCCN Master Work Plan Range 2}, "FFH"). Appreciated.