How to get an average for multiple columns

The AVERAGE() function will handle this just fine:

AVERAGE({Judge A Score}, {Judge B Score}, {Judge C Score}, {Judge D Score}, {Judge E Score})

It will ignore blank values when averaging.

Thank you! I thought it would too, but every time I tried the Airtable formula field kept trying to correct me and close off the formula, and adding extra field names was causing errors. I should’ve just typed it up in full and not let it try to guide me. :stuck_out_tongue: Appreciate it Jeremy!

I’m trying this myself now, and I have several columns to average (employee evaluation). I’ve tallied them all up as indicated above, and it says “NaN”. I had nothing in the other fields (still configuring), but then after the fact added data in case this was why, and nothing changed. HALP. :slightly_smiling_face:

Are you certain all of your fields are “Number” type fields?

I feel so silly! Of course that’s why it’s not working! :slightly_smiling_face: I manually made rating options (single select) then later decided to do Average. I’ll make the changes and I’m sure it’ll work. Thanks for the quick response :slightly_smiling_face:

It’s possible to convert those “ratings” into numerical values inside the formula, if you’d prefer that. 🤷🏻‍♂️

Really? I would! We’re new with Airtable but are loving it! How would I go ahead and do that? If you don’t mind sharing of course :slightly_smiling_face:

@Jenny_King - Edit - I had a mistake in my original post of this formula - hopefully you’ll get notification of this update to it.

Sure - you can follow this pattern in your formula field:

AVERAGE(
    {Number Field 1},
    {Number Field 2},
    SWITCH(
       {Single Select Field},
       "Good",  1,
       "Better", 2,
       "Best", 3
    )
)

AVERAGE(
    {Number Field 1},
    {Number Field 2},
    SWITCH(
       {Single Select Field},
       "Good",  1,
       "Better", 2,
       "Best", 3
    )
)

A bit too complicated to understand for this noob, but thanks for trying :slightly_smiling_face:

AVERAGE(
    {Number Field 1},
    {Number Field 2},
    SWITCH(
       {Single Select Field},
       "Good",  1,
       "Better", 2,
       "Best", 3
    )
)

So I am trying to get the average of 5 single-select fields. I’ve tried the formula several times and it’s not working.

Hi Jeremy, I hope you can help me. This is the formula that I am using to get the average of the 5 single-select columns and output them into another column.

AVERAGE({Responsiveness}, {Proactiveness},{Deadlines},{Platforms},{Problem Solving}, SWITCH({Responsiveness}, {Proactiveness},{Deadlines},{Platforms},{Problem Solving},".5",5 ,“1” ,1 ,“1.5” ,1.5 ,“2” ,2 ,“2.5” ,2.5 ,“3” ,3 ,“3.5” ,3.5 ,“4” ,4 ,“4.5” ,4.5 ,“5” ,5 ,“5.5” ,5 ,“6” ,6 ,“6.5” ,6.5 ,“7” ,7))