right click on the area at the bottom of screen and select "sum"

--
Greetings from New Zealand
Bill K
"PeachyCarol" wrote in message
...
total of selected cells should display at bottom of screen, instead "min="
displays How do I change this to show total?