It would be useful to have the 'Sum' button as a group button with a drop down list of other commonly used functions like AVERAGE, COUNT, MAX, MIN, and the last entry being 'more functions', which opens the function wizard.
OK, but adding 'more function' is the same as the nice icon that is left of the Sum, so IMO superfluous.
Well i was going to suggest disabling that button, but not sure how people would react to that. :D
I see no need to change that. It's a beautiful icon, room enough, and a distinctive visual element, and oh yes: fast access for those clicking :)
(In reply to Cor Nouws from comment #3)
> I see no need to change that. It's a beautiful icon, room enough, and a
> distinctive visual element, and oh yes: fast access for those clicking :)
Created attachment 109355 [details]
toolbar drop down in Quattro Pro
Adding other functions doesn't make much sense if you take the special handling into account that the Sum button provides, differentiating between mere data above or data interspersed with other SUM formula cells. I suggest to drop this idea.
Created attachment 134193 [details]
function split button in Excel
(In reply to Eike Rathke from comment #6)
> Adding other functions doesn't make much sense if you take the special
> handling into account that the Sum button provides, differentiating between
> mere data above or data interspersed with other SUM formula cells.
The special handling of auto selecting the range that happens when clicking the Sum button is a good feature and if the function in the list can benefit from the feature, it should auto select the range, but if it doesnt, then it should simply insert the function into the cell, just like it would simply insert '=SUM()' into a field that isnt near a range.