Formula using SUMIF & IF

[BiggyTwo]

Hi all,

I am using this formula: =IF(B6>=A6:A390>=B5,SUMIF(F6:F390,
"*8in*",E6:E390))
to:
Sum values in the range E6 to E390 where 8in is found in the
corresponding cells in the range F6:F390 and the values in the range
A6:A390 lie between the values contained in cells B6 and B5

It is not giving me the desired result so obviously there is something
wrong with my formula. Can anyone help me?

(Simply stated I want to sum those values in range e6:e390 if "8in" is
found in the string in range f6:f390 while the corresponding value in
range a6:a390 lies between the boundary conditions in cells b6 & b5)
(Hope I made myself clear.)


Thanks to all.

biggy

 

[Max]

One way ..

=SUMPRODUCT((A6:A390>B5)*(A6:A390<B6)*ISNUMBER(SEARCH("8in",F6:F390)),E6:E39
0)

 

[Max]

Oops, slight correction, should be:

=SUMPRODUCT((A6:A390>=B5)*(A6:A390<=B6)*ISNUMBER(SEARCH("8in",F6:F390)),E6:E
390)

 

[BiggyTwo]

Thanks Max, just the solution I hoped for. Thanks again.

Biggy