alphaexcel
Board Regular
- Joined
- Apr 21, 2008
- Messages
- 87
The sumproduct I am using fails because items in the final range contain the #REF error. These items do not need to be included in the count in any case as they would never meet the criteria specified in the 2 rows previous, which the sumproduct bases the calculation on. Any ideas?