View Single Post
 
Old 07-29-2014, 07:52 AM
whatsup whatsup is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

As I said - Yes you can, as long additional range is really empty, AVERAGE() ignores these cells. Empty means, that the additional cells may not filled with Zero neither with empty strings (="") as formulas might return.

The formulas used are Array-formulas. They tend to be slow, therefore it's recommended to keep ranges short for performance issues.

If you do any changes remember you will have to quit the changes by pressing Ctrl+Shift+Enter at one time instead of only Enter. With this Excel will then suround the formula by {} to mark the formula as Array-formula. Only that way the formula will return correct results.

Edit:
As to your second question, it's probably the result of above said
Reply With Quote