I am struggling with my countifs formula
I am trying to use a countifs formula in my sheet summary to compile some information. This is a failure log in our internal product testing. I want to see how many of a specific model have failed due to each of these reasons: Assembly, Materials, Process, or Other reason. So how many Hydra failed due to Assembly, Due to Materials, etc.
I think one issue is that I want all the instances of Issues accounted for.
Here is my formula: =COUNTIFS(Model:Model, CONTAINS("Hydra"@cell),[Issue 1 Failure Type]:[Issue 6 Failure Type],"Assembly)
Error cord: #unparseable
We have 3 types of Hydra, but for my proposes I don't need to break the data down into type of hydra, just if a hydra failed (or if any of our other models failed for one of the above reasons).
Help Article Resources
Check out the Formula Handbook template!