Nov 16 2021 10:27 AM
Nov 16 2021 03:57 PM - edited Nov 16 2021 07:40 PM
@lucysmomma.... 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.
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.
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.