COUNTIFS error

So, a simple formula (that worked before), is now not working:

=COUNTIFS([Approved 2024 $$]:[Approved 2024 $$], "", [Targeted Area]:[Targeted Area], "Atopic Dermatitis")

Even if I reverse the [Approved 2024 $$]:[Approved 2024 $$] and put it at the end; it won't look at that column and count those "out". It just counts the Total in the [Targeted Area] column.

What am I doing wrong?

Tags:

Best Answer

  • AravindGP
    AravindGP ✭✭✭✭✭✭
    Answer ✓

    Hi @Susan Swisher


    The formula seems to be counting the items when Approved 2024 $$ is blank AND Targeted Area is Atopic Dermatitis. Is that what you're trying to do? If you're trying to get a count where the Approved 2024 $$ is not blank, your formula should be =COUNTIFS([Approved 2024 $$]:[Approved 2024 $$], <>"", [Targeted Area]:[Targeted Area], "Atopic Dermatitis")

    Thanks,

    Aravind GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭✭
    Answer ✓

    Hi @Susan Swisher


    The formula seems to be counting the items when Approved 2024 $$ is blank AND Targeted Area is Atopic Dermatitis. Is that what you're trying to do? If you're trying to get a count where the Approved 2024 $$ is not blank, your formula should be =COUNTIFS([Approved 2024 $$]:[Approved 2024 $$], <>"", [Targeted Area]:[Targeted Area], "Atopic Dermatitis")

    Thanks,

    Aravind GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

  • Susan Swisher
    Susan Swisher ✭✭✭✭✭✭

    @AravindGP !! that was the answer <> I knew I was doing something wrong. Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!