View Single Post
  #1   Report Post  
Mosqui
 
Posts: n/a
Default sumproduct wildcats

Thanks very much for all the answers, I went through the posts and learnt a
lot, but I could find exactly what I need.
The problem I've got is that one of my criterias is part of the cell.
So, to be clear; I need all the cells which start with the word "pipe".
pipe 100 w
sp-pipe
pipet 333

From these three I just need to get the first one.
=SUMPRODUCT((Original!A2:A9101="024-02")*(Original!G2:G9101="400")*NOT(ISERROR((SEARCH ("pipe",Original!C2:C9101))))*(Original!H2:H910 1))

This is what I'm using at the moment.

Thanks in advance, and again congratulations to all the people who
colaborate with these answers.

Martin