ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Unexpected Function (https://www.excelbanter.com/excel-worksheet-functions/123338-unexpected-function.html)

[email protected]

Unexpected Function
 
Usually when I select a range of cells with my mouse, I am able to see
the sum of the values in those cells at the right bottom hand corner of
Excel. However, not it just gives me the "max" value of that range.

I'm not sure how this function got toggled, but I need to get back to
the original sum function. I tried resetting my computer but it didn't
work.

Please help. Thanks!


Gary''s Student

Unexpected Function
 
Right-click that MAX and select what you want.
--
Gary''s Student


" wrote:

Usually when I select a range of cells with my mouse, I am able to see
the sum of the values in those cells at the right bottom hand corner of
Excel. However, not it just gives me the "max" value of that range.

I'm not sure how this function got toggled, but I need to get back to
the original sum function. I tried resetting my computer but it didn't
work.

Please help. Thanks!



David Biddulph

Unexpected Function
 
Right-click on the status bar, and it will let you select between the
functions.
--
David Biddulph

wrote in message
ups.com...
Usually when I select a range of cells with my mouse, I am able to see
the sum of the values in those cells at the right bottom hand corner of
Excel. However, not it just gives me the "max" value of that range.

I'm not sure how this function got toggled, but I need to get back to
the original sum function. I tried resetting my computer but it didn't
work.

Please help. Thanks!





All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com