- May 23, 2003
Column M has a specific value at cell M5 that I want to search for. The same can be said for the contents of cells S14 and S190. But when I run the above forumula, I get an answer of 0. If I remove the end argument, i get 74. If I remove themiddle argument, I get 14. Can I just tack on extra arrays to a sumproduct? I want a result that diplays the number or rows with either M5 & S14 or M5 and S190. Or, should I just run two sumproducts. I think i need an OR in there somewhere?