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. 
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. 
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.
Are you certain all of your fields are “Number” type fields?
I feel so silly! Of course that’s why it’s not working! 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
I feel so silly! Of course that’s why it’s not working! 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
It’s possible to convert those “ratings” into numerical values inside the formula, if you’d prefer that. 
♂️
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
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
@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
)
)
@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
)
)
A bit too complicated to understand for this noob, but thanks for trying
@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
)
)
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))
