is this formula will work in smartSHEET?

=SUMIFS([Percentage RFQ]@row, name:name, "Michal Seelbach") / COUNTIFS(name:name, "Michal Seelbach")

hello, is this formula will work in smartsheet? Please help as soon as possible. Thanks

Answers

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭

    @kumars23

    Try removing the @row from the first argument in your SUMIF and putting

    =SUMIFS([Percentage RFQ]:[Percentage RFQ],name:name, "Michal Seelbach")

    This will sum all the values from the Percentage RFQ column where the name is Michal Seelbach

    =COUNTIFS(name:name, "Michal Seelbach")

    This will count how many rows have Michal Seelbach in the name column

    =SUMIFS([Percentage RFQ]:[Percentage RFQ],name:name, "Michal Seelbach")/COUNTIFS(name:name, "Michal Seelbach")

    This will divide the answer from the Sumif function by the answer to the countif column.

    See here for example


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!