skinfreak
Board Regular
- Joined
- May 23, 2003
- Messages
- 152
Code:
=SUMPRODUCT(($M$5:$M$434=$M$5)*($S$5:$S$434=$S$14)*($S$5:$S$434=$S$190))
To clarify:
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?
Thanks!