Discussion Re: Error in cell in Excel
https://techcommunity.microsoft.com/t5/excel/error-in-cell/m-p/2971789#M122486
<P><LI-USER uid="1220547"></LI-USER> </P>
<P>That's not obligatory. You can use =SUM(A1) without problems or errors, although it makes little sense. A more common use would be something like =SUM(A1,A4) or =SUM(A1:A4)</P>Tue, 16 Nov 2021 18:58:09 GMTHans Vogelaar2021-11-16T18:58:09ZError in cell
https://techcommunity.microsoft.com/t5/excel/error-in-cell/m-p/2971684#M122480
<P>Hi, I am trying to figure out a spreadsheet that is totally messed up. Please forgive my ignorance, but in order for a SUM to work properly, doesn't it have to have more than one cell number in it?</P>Tue, 16 Nov 2021 18:27:54 GMThttps://techcommunity.microsoft.com/t5/excel/error-in-cell/m-p/2971684#M122480lucysmomma2021-11-16T18:27:54ZRe: Error in cell
https://techcommunity.microsoft.com/t5/excel/error-in-cell/m-p/2971789#M122486
<P><LI-USER uid="1220547"></LI-USER> </P>
<P>That's not obligatory. You can use =SUM(A1) without problems or errors, although it makes little sense. A more common use would be something like =SUM(A1,A4) or =SUM(A1:A4)</P>Tue, 16 Nov 2021 18:58:09 GMThttps://techcommunity.microsoft.com/t5/excel/error-in-cell/m-p/2971789#M122486Hans Vogelaar2021-11-16T18:58:09ZRe: Error in cell
https://techcommunity.microsoft.com/t5/excel/error-in-cell/m-p/2972946#M122533
<P><LI-USER uid="1220547"></LI-USER>.... SUM(A1) might make sense if A1 might be text that you want to be treated as zero in an arithmetic expression. I prefer to use N(A1), since that is its purpose.</P><P> </P><P>SUM($A$1:A1) can be very useful. When it is copied into another cell to the right and/or down, the range is automagically extended. For example, as you drag the formula down the column, the reference becomes SUM($A$1:A2), SUM($A$1:A3), etc.</P><P> </P><P>If you are having trouble figuring out some problems, I suggest that you attach an example Excel file and describe the problems so that we might be able to help you.</P>Wed, 17 Nov 2021 03:40:33 GMThttps://techcommunity.microsoft.com/t5/excel/error-in-cell/m-p/2972946#M122533Joe User2021-11-17T03:40:33Z