I want to create a formula to reference 2 columns in another sheet.

colin alexander

HI. I am looking to create a formula that will reference another sheet called Minor Issues Log. I want to record in my sheet if a full NCR was required by referencing the column "Is a full NCR required" and searching for "yes" and also reference a second column the other sheet called "Area / Dept". The end result i am looking for is a list of how many Minor Issues went on to require a full NCR against each department. The formula i have so far is =COUNTIF({Minor Issue Log Range 3}, "Yes", AND({Minor Issue Log Range 2}, "Mould")), but this is returning #INCORRECT ARGUMENT SET. Can anyone help please?

colin alexander

Hi everyone.

The formula that finally worked was =COUNTIFS({Minor Issue Log Range 3}, "Yes", {Minor Issue Log Range 2}, "Mould")

Thanks

Paul H

Try

=COUNTIFS({Minor Issue Log Range 3}, "Yes", ({Minor Issue Log Range 2}, "Mould")

https://help.smartsheet.com/function/countifs#:~:text=Counts%20the%20number%20of%20times,their%20respective%20ranges%20are%20met.&text=The%20group%20of%20cells%20to%20count.&text=The%20value%20that%20determines%20which,!%22%2C%20or%20%3E25.

colin alexander

Hi Paul. Thanks for the suggestion. I have put this into the sheet and it comes out with #UNPARSEABLE

colin alexander

Hi everyone.

The formula that finally worked was =COUNTIFS({Minor Issue Log Range 3}, "Yes", {Minor Issue Log Range 2}, "Mould")

Thanks