hello,
i need to count how many times two different products show up in date ranges.
one issue: one of my products i need to search for any product with word pea
second issue: my formula results in zeros when i know i have 8.
here my formula: =SUMPRODUCT(--($E:$E>=A2),--($E:$E<=B2),--($D:$D="corn"or"pea"))
here is some data to work with:
Capture.JPG
Bookmarks