Something about auto sum

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Excel has a button which can sum in a special range. But I was confused with
that button.I don't known what's the rule or how does it function.So, if you
know please tell me.Thanks a lot!
 
Hi Jim

if you click in an empty cell & press the autosum button it looks for a
range of numbers above (adjacent to this cell) to add up and will
automatically select the range if one is found.
if no list is found above it looks to the left.

if you select a range and an empty cell adjacent to the range and press the
autosum button it populates the empty cell with the sum of the selected
range.

hope this helps
Cheers
JulieD
 
Thank you!
It seems much clear now.I didn't know there is a shotcut to
autosum(ALT&=).It's wonderful!
 
Back
Top