Share via

@sum function

Anonymous
2018-11-30T12:26:02+00:00

when i try to use the @sum function, the result produces #FIELD! - how can I fix this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-12-04T15:08:58+00:00

    That error is returned when you have linked data types. When you use =sum(b2.b5) the dot means that your formula is looking for the data b5 of  field b2, neither of which exist.  Use

    =SUM(B2:B5)

    Note the colon, not period, and all should be well.

    (Note: November 27, 2018. Data types have been released to all Windows Office 365 subscribers, except in a few geopolitical locations (coming soon). If you are an Office 365 subscriber, make sure you have the latest version of Office.)

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2018-12-03T22:26:29+00:00

    This didn't help.  Same #!FIELD error is returned.  I entered =sum(b2.b5) and same error.  WTF!!! I"ve been on excel for 30+ years and now they screw with a basic formula?  What genius programmer did that.  Sorry, very frustrated...…..

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2018-11-30T15:39:47+00:00

    There is no @SUM function - if you type

    =SUM(

    and then select the cells with values, type

    )

    and then press enter, you should get the sum from the selected cells.

    If you type =@SUM( and perform the same steps, you will actually create a hyperlink to a mail address...  you don't want to do that.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments