COUNTIF with AND Statement

Options

Is someone able to help? I cannot figure this out.

The "working sheet" is where I'm inputting the formula.

I want to count if the form was received and by FBC.

REFERENCE SHEET

WORKING SHEET


Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 04/06/20
    Options

    Hi Cory,

    It sounds like you just need a COUNTIFS function (with an S at the end to indicate multiple criteria). Try this:

    =COUNTIFS({Form Received Column}, 1, {FBC Column}, FBC@row)


    The ranges {in these} are cross-sheet references to your Reference Sheet. The first 1 indicates that you're looking for a check in the box, and the second criteria listed, FBC@row, means you're looking for the FBC type that's in that current row... for example, AC.

    You can then drag-fill this formula down your completed column for the Count.

    Let me know if you have any questions about this!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!