AverageIF formula

Options

Hi all,

I probably have a stupid question.

But in the attached example, I would like to calculate the average from 'chance to win' column if 'Football teams = KRCG'.

In addition, I would also like to calculate the average from 'chance to win' column if 'Football teams = RSCA' and 'Yes or No = Yes'?


Best Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer βœ“
    Options

    Hi @Jef Snyders,

    For your first question:

    =AVERAGEIF([Football teams]:[Football teams], "KRCG", [Chance to win]:[Chance to win])

    For the second:

    =AVG(COLLECT([Chance to win]:[Chance to win], [Yes or No]:[Yes or No], "Yes", [Football teams]:[Football teams], "RSCA"))

    Hope this helps, but if you've any problems/questions, then just post! πŸ™‚

  • jmyzk_cloudsmart_jp
    jmyzk_cloudsmart_jp ✭✭✭✭✭✭
    Answer βœ“
    Options

    Hi @Jef Snyders

    Not stupid at all. You've raised an important point about the limitations of the AVERAGEIF function. Dealing with the lack of AVERAGEIFS can be challenging, but some workarounds can help us perform similar calculations.Β πŸ˜€

    Here is what I would do;

    KRCG:

    =AVERAGEIF([Football teams]:[Football teams], "KRCG", [chance to win]:[chance to win])

    RSCA & Yes

    =AVG(COLLECT([chance to win]:[chance to win], [Yes or No]:[Yes or No], "Yes", [Football teams]:[Football teams], "RSCA"))


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!