Formula Error

Katherine Camacho

I used a current formula in one sheet to format a new one and cannot figure out the error issue. Its saying #Incorrect argument set

=IFERROR(COUNTIF([Medical Necessity]@row:[Collection Plan]@row, "p" / COUNT([Medical Necessity]@row:[Collection Plan]@row), ""))

Kelly Moore

Hey @Katherine Camacho

I moved a couple of parentheses around.

=IFERROR(COUNTIFS([Medical Necessity]@row:[Collection Plan]@row, "p")/COUNT([Medical Necessity]@row:[Collection Plan]@row), "")

Does this work for you?

Kelly

Kelly Moore

Hey @Katherine Camacho

I moved a couple of parentheses around.

=IFERROR(COUNTIFS([Medical Necessity]@row:[Collection Plan]@row, "p")/COUNT([Medical Necessity]@row:[Collection Plan]@row), "")

Does this work for you?

Kelly

Katherine Camacho

It worked, thank you! Im still trying to flip excel to smartsheet in my brain and I'm not great at either! Happy New Year