Having issue with COUNTIFS

Options
ChrisUPC
ChrisUPC ✭✭✭✭

I am having difficulty with a COUNTIFS statement.

I am trying to get a count of parts from an "INTAKE" sheet containing current orders and the parts associated with them. The "INTAKE" sheet has all of the order data listed by row including the ranges I want to count. One range contains multiple (60+) columns with parts ordered AND the other range is a single column with the stage of production from that sheet.

MULTIPLE COLUMNS SINGLE COLUMN The formula is: =COUNTIFS({UPC Parks - Total Ordered}, Part@row, {UPC Parks - Stage}, "TO BE CAST")

I broke it down into singular COUNTIF statements and they works if it only has one condition, however as soon as I add the second condition, it returns #INCORRECT ARGUMENT.

I have also tried: =COUNTIF({UPC Parks - Total Ordered}, AND({UPC Parks - Total Ordered} = Part@row, {UPC Parks - Stage}))

Any help would be appreciated!!!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!