Have you tried returning 0s where there are blank cells? The ZN() function may help with this.
Returns the expression if it is not null, otherwise returns zero. Use this function to use zero values instead of null values. ZN([Profit]) = [Profit]
If this doesn't help, you can post a packaged workbook with some sample data that others can use to evaluate the problem. Cheers.
1 of 1 people found this helpful
Matthew is correct. To clarify a little, you will get a NULL if you attempt to add it to any other value. In your example above, it is likely that Likes is NULL (at least in some cases), so try something like:
ZN(Retweets) + ZN(Comments) + ZN(Likes)
That way if it were originally:
30 + 50 + NULL which results in NULL
it would be calculated as
30 + 50 + 0 = 80