looking for some help on an issue I am having with a prompt stating that a formula is two long. I am using SUMPRODUCT ISNUMBER SEARCH formula for multiple selections, approx 30, and the way I am entering the code works but "formula to long" error message appears before I am able to enter criteria for all 30 selections. I am just adding each of the equations to each other to return a total. attached is a portion of the formula. Is there a different way of listing the criteria that is more efficient?? Please help!!
![]()
Please Login or Register to view this content.
Bookmarks