CrazyBritGuy
New Member
- Joined
- Dec 10, 2019
- Messages
- 13
- Office Version
- 2016
- Platform
- Windows
The syntax for AVERAGEIF states:
Range Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers.
But when I create a named range nonContig as =Sheet1!$F$5:$F$10,Sheet1!$F$13:$F$17
and in cell G3 enter =AVERAGEIF(noncontig,"<10") I get #VALUE
What's wrong with me?
Range Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers.
But when I create a named range nonContig as =Sheet1!$F$5:$F$10,Sheet1!$F$13:$F$17
and in cell G3 enter =AVERAGEIF(noncontig,"<10") I get #VALUE
What's wrong with me?