Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |