Just a heads up if you don’t want to filter, you can also use the BLANK() function to serve this purpose. Something like

IF(SUM(Number+{Number 2}+{Number 3})>0, SUM(Number+{Number 2}+{Number 3}), BLANK())

Hey ​@lwetherby,

As mentioned ab​@DisraeliGears01, the two  formulas/expressions that you’ll want to be using are IF() and BLANK().

Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel

​@DisraeliGears01 will that formula still actually add up the numbers? or do I need to put that after the SUM() formula that adds everything up?  Thanks!

In my example the “Number” fields are placeholders, so if you just replace them all with your specific fields it should work (I forget the field names you had). So basically it’s IF( SUM(All your fields)>0, SUM(All your fields), BLANK() )

That makes the formula add up your numbers and if it’s more than 0, display the sum, otherwise display a blank. Then you can use the bottom function for average. I didn’t account for negative numbers here tho, so hopefully you’re just looking at blanks or positive integers. 

​@lwetherby if you are still having issues, make sure to send over the name of your fields involved, explain the calculation to be done, and we’ll provide the exact formula :D
 

Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel