Replies

solved problem user server name instead of IP address

FYI.
The manufacturer got back to me and FN+F9 enables/disables Touchpad on an ASUS.

Again thanks for your comments and help.

thanks to all. Went with creating mouse shortcut

thanks for the help!

The lock and hide would work. Thanks.
As for pdf, the other side has to be able to “test” the results against their method.

thanks for saving me a lot of drudgery!
greatly appreciated

worked.
thanks!

worked.
Thanks!

copying values only, although I’d be interested in knowing how to maintain links, should I have a small data set in the future
thanks for the help

thanks!

Thank you.
I figured there had to be an easy way………..

The fact that you didn’t see and #NUM! error made me check versions.

I’m using Excel 2007. I brought the spreadsheet into another computer with Excel 2010 and the formula works correctly. I checked on another computer with Excel 2007 and it doesn’t work correctly there either.

So now my question is what is wrong with excel 2007? The help says =geomean(a1:a10) should work.

Thanks for the help.

Data is all positive and > 0.
Example worksheet attached.

Could my problem be the difference between a colon and a comma; i.e., =average(a1:a10) vs =geomean(a1,a10) ?
see cells K3,L3 in attached.

USB, unfortunately
thanks

suspicions confirmed!
I didn’t consider the sumifs command.
THANKS!