=SUM('Box Office Revenue ($)')/COUNT('Box Office Revenue ($)') jus add a space between Revenue and ($) then the formula will work