I am really struggling with COUNTIFS syntax and hope someone can shed light on what I am doing wrong.

I have 3 sheets. Sheet1 has assets from company a, Sheet2 has assets from company b and Sheet3 is my metrics sheet that has the COUNTIFS code.

On Sheet3, I have a COUNTIFS statement that is supposed to count the number of "In Stock" items from Sheet1 column 1 and Sheet2 column 1. The syntax is:

=COUNTIFS({Sheet1 Range 1}, "In Stock", {Sheet2 Range 1}, "In Stock")

The above code results in #INCORRECT ARGUMENT SET.

If I split the above code into two separate COUNTIFS statements, then there is no problem so I know the data is right.

Any suggestions?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!