Skip to main content
Solved

Can i create a sum formula that returns Blank instead of 0?

  • October 15, 2025
  • 5 replies
  • 50 views
lwetherby
Forum|alt.badge.img+3

NEVERMIND - I filtered out the empty ratings. Thanks!

Best answer by DisraeliGears01

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())

 

    5 replies

    DisraeliGears01
    Forum|alt.badge.img+21
    • DisraeliGears01
    • Genius
    • 301 replies
    • Answer
    • October 15, 2025

    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())

     

    Mike_AutomaticN
    Forum|alt.badge.img+28

    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

    lwetherby
    Forum|alt.badge.img+3
    • lwetherby
    • Author
    • New Participant
    • 4 replies
    • October 16, 2025

    ​@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!

    DisraeliGears01
    Forum|alt.badge.img+21

    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. 

    Mike_AutomaticN
    Forum|alt.badge.img+28

    ​@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


    Terms & ConditionsAccessibility statement