I want to use the below formula but instead of SUM IF I need to work out Average IF

=SUMIFS({Quality Checks Tracker FY21-22 Range 1},{Quality Checks Tracker FY21-22 Range 2}, [Primary Column]@row)

So i want to work out the average %% if the first column says "full Inspections" ect ect

I have the formula working with sumif on the first number column but now need to work out the average %%



Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 07/19/21 Answer ✓

    @Sue van Niekerk

    If you like share me as an admin on a copy of your sheet after removing any sensitive data and I will check it for you. Because it's words on my sample sheet.

    My email: bassam.k@mobilproject.it

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!